Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. palmese

    Gen. Question about updating VB Cell Ranges

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

    Gen. Question about updating VB Cell Ranges

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

    IF Function with INDEX and MATCH Function

    Yep, that did it. Many thanks!!!
  4. palmese

    IF Function with INDEX and MATCH Function

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

    Restricting Cell Input Contingent on ComboBox Selection

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

    ROUNDING All Cells In An Excel Worksheet

    Many thanks to all who replied!!! Works great.
  7. palmese

    ROUNDING All Cells In An Excel Worksheet

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

    Unprotecting ComboBoxes

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

    Restricting Users From Typing Values Into ComboBox

    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 =...
  10. palmese

    Restricting Users From Typing Values Into ComboBox

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

    ComboBox Question -- Excel and VB

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

    ComboBox Question -- Excel and VB

    Because I need to populate cell A1 with the ComboBox selection (there are 12 to choose from). Sorry for the confusion.
  13. palmese

    ComboBox Question -- Excel and VB

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

    ComboBox Question -- Excel and VB

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

    ComboBox Question -- Excel and VB

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

Part and Inventory Search

Back
Top