Answer Questions

• gfather Take out the ability to input values on combo box?

  How do I take out the ability to input values on a combo box For instaance, if I want the user to select the month Thanks, that helped a great deal. Now, how do i make it default to the first item in other words, before i put anything in it, i was referencing something that wasn't there yet. I had the listbox down right but i had it before i listed all my items. What do you mean Great, thank you very much for your help. I had the listbox down right but i had it before i listed all my items. Hi You can set the property "style" to fmStyleDropDownList You can set the ListIndex property to 0 in VBA code Combox1.ListIndex = 0 ...Show All

• LauraCapatina Creating my own object in VBA

  I've searched the forums, but I haven't found an answer or example in VBA. I'm trying to create an object, so I can wrote the program easily. In my object, there are variables, subs, functions and another objects as well. My problem is how to define the functions and subs. Here's my object: Private Type T_Vertice 'My secondary object      Moneyness As Double ' data      Vol As Double ' more data      Sub Add(ByRef Range_Vols As Range, ByRef Range_Moneyness As Range) End Type      Private Type Dados_Meses    ' My main object.      Data As String  ' more data      Count As Long ' more data & ...Show All

• jdr5 Architecture - what it is and what it will be

  As an initial discussion which can be helpful to all of us I would like to hear opinions of my colleagues regarding the basic question of just what is Architecture and what we would like it to be in the future. Regards, Behzad I recently found an article on architecture that may be useful here. I link to it on my blog article on The Role of Architects: Confining Complexity through Form . - Dennis Architecture is the blue-print of the solution / product / system. This gives a bird's eye view of the system. This takes business form / technical form based on the architecture we provide. This is mainly to convey what the system will contain and provide. It talks about functional, non-functional, perspective. And also t ...Show All

• herman_hhh HELP NEEDED

  Hi, I need help with a excel file. I don't know VBA. I’m willing to learn. I have excel pro 2007 beta loaded. Since earlier versions can't do as much with conditional formatting. These are questions are in two break downs. For a scoring system in horseshoes. I would like to lock or protect all the sheets the workbook using vba. And still be able to add data to unprotected cells on one of worksheets. I need vba macro to do this so all the sheets are protected and run the macros but still be able to edit scores in column cells when a round is finished. 2nd question There are 3 worksheets. On the team Random Matches Worksheet when you click the green button on that sheet which runs the macro. It will chang ...Show All

• LarryETL DLookup help?

  Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All

• Oliver 123 Adding table in Word Doc over writes previous lines

  Please excuse what is probably a simple answer - I am very new at VBA. I am using VBA in Excel and attempting to write to a Word document. The document is to have a few lines of text followed by a 6x6 table. When I do a: Set tableNew = .Tables.Add(.Range, 6, 6) it overwrites the previous lines I wrote. I'm sure there's a way to place this table in the appropriate spot in the document, but I've been unable to find any documentation on this. Can you offer any help with this Thanks, kgkidd This was my first question using this forum.  Doesn't seem to be much assistance here - not a single response.  Unfortunately I still haven't found the answer.  Possibly the question was more d ...Show All

• hellborg Referencing unregistered DLL

  Hi all, I've had kind help with part 1 of my problem somewhere else on the forum, but I think part 2 should be posed here. What I am trying to do is create a .dll-file (TestDLL) that contains a function (StartMe) initiating a form (frmMain) and then call that form from both an EXE-file and an Excel add-in. The DLL-file I created with VB 2005 could not be registered with Windows, so I could not call the function StartMe from within the EXE. As it turns out, I could simply include a reference to TestDLL in the EXE-file, telling it where to look for the function StartMe. Logical deduction would therefore tell me I should also include a reference to TestDLL in the VBA-code, telling that where to find StartMe. Is it possible to do ...Show All

• Grotius Delete Unwanted rows based on value in cell

  Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "Total", if not i go to the next row but if it does i must then delete this row and go to the next. I then need to delete each of the next rows until i find the next cell that contains the value "Product", delete this cell and then go through each of the next rows until i find the next cell that contains the value "Total&quo ...Show All

• Dr.Virusi Excel COMBOBOX data sources

  Is it possible to use access tables as datasources for excel comboboxes or for in-cell list boxes I don't think it is but I had to ask. To clarify. some cells in my sheets have listbox attributes. Normally the source for this is a field in the same sheet. With a combo box, the source can be a different sheet in the Work book. Is it possible to use an Access table as a data source for either of the aforementioned controls Niall Hello Niall, It is possible to read an Access table using ADO in Excel. I suppose then you could read the records of a table and use them for your combobox. Chas ...Show All

• Gunnar Adler String Functions

  Does anyone know if there's a string function that removes new lines from a string (where return has been hit to start a new paragraph) It's kind of like the Trim functions I'm looking for, but these only work with trailing spaces, not where a new line has been started. Cheers! Keith Cheers guys! I'll give it a go! Hi, I unmarked CetinBasoz  post as the answer as the code given is VB.NET and not VBA. Hey man, Try the Replace() function. Just replace all the vbCrLf in the string with "" and that will remove them. nae bother big yin. :) Your right. I didn't pay attention to on what forum it was:) ...Show All

• fspilot2006 Control Break Trap will not work whilst Userform is displayed

  Hello All, In Excel I have statement Application.OnKey "^{BREAK}", "Sub_Trap_Break" This is okay at all times when there is no Userform being displayed but when there is a form this does not work. Any ideas how to overcome this I am trying to stop users get to the spreadsheet. To stop this I have: 1) Form event Query Close 2) The sheet only becomes visible when macros are enabled otherwise it is xlVeryHidden 3) The cells font and background colours are the same so nothing can be seen ! and it is protected at the appropriate times 4) Menus are disabled But that fact that on control Break (when a form is displayed) the VBE window appears is irritatting, any ideas (No code is displayed as t ...Show All

• evan_t Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi Brenda, I have contacted Summit software and unfortunately no luck with them. Please help us. Regards, Steve Unfortunately, this isn't enough information to even begin guessing at what might be going on. Would there be any way to obtain a copy of the application to try and reproduce the failure Does the error dialog have a ...Show All

• vgrigor Outlook automation with encrypted signed email

  Hi, I recieve a digital signed email daily which contains a zip file. I would like to know if there is a way to automate the extraction of this attachment. I have tried all standard methods but where I run into problems is with the fact the email is encrypted when recieved. It required someone to manually open the message, as it won't appear in the preview pane, before the macro can access it. It always returns nothing and fails with the following statement ... Set thisMail = myFolder.Items.GetFirst() Is there a way to automatically unlock this message in the macro or is there some other way I should be doing this Thanks in advance for any insight you can provide. Christopher New have i ...Show All

• J M B Auto Indentation for VBA

  Hello, I am still new to VBA IDE. I am wondering if there is add-in or tools to make VBA do auto indentation like Eclipse editor for Java. Any help are very appreciated. Thanks in advance. Excel MVP Stephen Bullen has a Smart Indenter add-in on his web site, two versions in fact, VBA and VB6. Stephen's site is at http://oaltd.co.uk - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ Go to Tools|Options. On the Editor Tab there is a "AutoIndent" checkbox. I'm sure you can handle it from there. (unless you are looking for a tool to re-structure the indents in poorly indented code.) rusty ...Show All

• Eslam Afifi VBA - Create View

  Is it possible to create views using VBA Create view test as select field1 from tblRecords; Are you refering to a view in SQL Server or a query within Access, or where do you want to create this view, and what do you want it to be a view of (an Access table, a range in Excel, or what ). ...Show All