CajunCenturion, Thanks so much! That makes a lot of sense. My follow up question would be how should define/implement the 2 dimensional array called TableMap. I don't have a lot of programming experience. I understand the concept, I'm just not sure how to implement it in VB. And...
I have a general VB question that I was hoping someone can shed light on.
I have developed an elementary expense report for my company using Excel as the interface and some VB code. The excel interfaces includes a number of comboboxes with user selections. An example of the code is as...
I have the following formula, which is getting me very close to what I need:
=IF(B37="Fairchild Imaging","TCGROUP")&(INDEX($B$50:$C$681,MATCH($A$66,$B$50:$B$681,0),2))
Some Background:
I have the user make a selection from a ComboBox (i.e. user chooses "Option 1"...
I have an Excel Employee Expense template where the user makes selections from a number of ComboBoxes.
The problem I am having is that I need to limit the user to not be able to type in amounts in cells (i.e. B12:B30) unless they have chosen a selection in the ComboBox. An example would be a...
I have a number of spreadsheets with amounts hard-coded into the cells and denoted in millions.
Example:
Cell A1 = Cash Cell B1 = 1,000,000
Cell A2 = Fixed Assets Cell B2 = 3,500,000
Is there a way to round the numbers to the nearest thousandth (Cell B1 would be 1,000; Cell B2 would be...
I have an Excel 2000 template in which users will (1) select from a series of dropdown menus and (2) input amounts into specified cells. Since this template will be accessible via the company's Outlook Public Folders - I need to protect the worksheets.
My question concerns protection related...
Thanks Zemp! Worked like a charm.
I had one follow-up question. Now that I have set the combobox.style property to 2-Dropdown List, I am getting an error in my code related to the ClickButton I set up in order to "Reset" the form. The following is the code I used -- ComboBox1.Text =...
I have an Excel template that has a number of ComboBoxes in which a user will make selctions. I am having the problem of the user being able to override my ComboBox and type anything they want in the Box, thus circumventing the ComboBox choices. Example = ComboBox will have the choices...
my bad...it was a VB Code problem I had related to the Reset button I had set up (basically it wasn't saving my LinkedCell). you have been a great help and i thank you very much. take care.
No, say the user selected the following from the ComboBox "Project1".
A cell would populate the text value from the ComboBox(i.e. Project1). Then from there I would use the VLOOKUP to specify the appropriate relationship (in this case if Project1 was selected - I would put in the...
THANKS SKIP!!!
Unfortunately, I think I might be messing up the function. I am typing the following in the cell:
=Value("ComboBox1.Value")
it is returning the #Value! Excel Error. Any suggestions. Thanks for your help.
I am creating an Excel expense report template for my company. It contains ComboBoxes for users to select different projects to charge their expenses to. On the bottom of the template is an area that will be used for the accounts payable clerks to key in information based on the ComboBoxes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.