Summary: Hi I was wondering if anyone knows how to collect data from excel, and code it in VBA so it transfers it into a combo box in VBA, because i'm doing a ...
Summary: Will someone PLEASE tell me how to use wildcards in VBA IF...THEN statements! Here's an example of what I'm trying to accomplish: If ActiveSheet.Name ...
Summary: Hi, There are three main things to know about Dates and Times in Excel 1. Excel holds dates and times as a single decimal number, with the decimal par...
Summary: Hi, I am using Office 2007. I am trying to use the FIND function in VBA, Excel, to find a numeric value and return its row number. The value surely ex...
Summary: What did this function do? Is it possible that URLEncode was a User Defined Function. A User Defined Function is a function written in VBA and made ac...
Summary: I have a database table which contains client information. I have created a form where you use a dropdown box to choose a field to search by, then ty...
Summary: VBA for Office 97 is different then the VBA for Office 2K and/or higher. It is likely, although not necessarily a fact, that they will not work. I hav...
Summary: Im trying to use MS Flex Grid in access to display the results of a SQL query that is executed from VBA. After the results are displayed the user mu...
Summary: Hello DerbyDad03, I apologise for not stating all the overall requirements at the first time as I was trying to learn the basics and work your solutio...
Summary: I'm thinking the only way to do this is with a User Defined Function. As it turns out, I found one that seems to work. Here's what I did: I put your t...
Summary: Yes, you can do it with one line, but the line would be slightly different than the others. The first 2 lines are not forcing anything in the Excel sh...
Summary: The line that sets the number format is used in a macro, which is placed in VBA module. If you need to change the format based on a cell's content, yo...
Summary: I'm confused, but we'll get to that later. First, about your code: As far as I can tell, your code is supposed to prevent users from editing any cell ...
Summary: I'm confused by your question. There are 3 common methods for working with a range in VBA: 1 - Using hardcoded strings e.g. Range ("B1:AG5") 2 - Calc...
Summary: Take a look at the GetOpenFilename method in VBA help. Then modify the following line something like this: With ActiveSheet.QueryTables.Add(Connection...
Summary: I guess it could be done, but it's going to take some creative thinking on your part. In VBA, each fill color has a Interior.ColorIndex value. For exa...
Summary: I just wanted to let you know that I've tried a few things both at home and at work and there does not seem to be a workaround for this. I tried using...
Summary: Hi there! I'm just beginning the long road in learning VBA and already have an immediate need for some code that is quite beyond me. I have an excel w...
Summary: This one is strange. I have a database that opens up with a Switchboard. It works fine on my home PC, other PC and was working on my work PC. I got...
Summary: Thanks Humar. I tried your suggestion by copying your code into the module linked to the main excel invoice sheet. The Combobox in question is Combob...
Summary: I don't do a lot with User Forms or Combo Boxes, but this was a chance to play. I modified the code found in the Mr. Excel thread I suggested in my pr...
Summary: what do you want the macro to do? To take data input and then place them in various cells, without you having to click on each cell in turn? There is...
Summary: thank you, that's exactly what I need, but I don't know how to write that in VBA... If anyone knows please suggest some code for my problem... ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
