Search results for query: *

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&quot...

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...

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...

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...