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

    Removing a custom menu

    Mike: Thanks agin for the tip! -Zubin
  2. Zubinsum

    Removing a custom menu

    Ok, I got it. I found a typo in my remove menu macro. Thanks again Rmike.
  3. Zubinsum

    Removing a custom menu

    Rmike: Yes, I have tried that. The new menu appears even tho there is no code for it. The menu is unaffected by a delete menu macro (or command). :( Thanks for the input. -Zubin
  4. Zubinsum

    Removing a custom menu

    I am running Excel2000. I had a workbook with a macro for a custom menu, but now this custom menu appears on all my workbooks, including new ones. The workbook containing the macro has been deleted and I can't see any code that would bring up this menu. Anyone have any ideas on how I can fix...
  5. Zubinsum

    Excel ComboBox Simple Question

    By the way. Thank you for your reply. All input is appreciated.
  6. Zubinsum

    Excel ComboBox Simple Question

    Yes, it is the later. The combobox will update if the named range is on the same sheet, but there seems to be a bug that doesn't allow it to update when it is on a seperate sheet. It does however update upon reloading the workbook.
  7. Zubinsum

    Excel ComboBox Simple Question

    I am changing the list (inserting a cell into the named range) through a macro. I should mention, the named range is on a different worksheet (in the same work book). In any case, the combobox doesn't update. You can try it yourself. Do you know a command to update the combobox?
  8. Zubinsum

    Excel ComboBox Simple Question

    I have a combobox that does not update when the named range to which it refers is updated. Is there a command to reload or update a ComboBox in VB Excel? If so, could someone please provide the exact syntax?
  9. Zubinsum

    Updating a combo box's named range in excel

    The ComboBox is named ComboBox1... I get the same error. Am I doing this right? Is the command line that you suggest at the end of the macro: "ComboBox1.Update"?
  10. Zubinsum

    Updating a combo box's named range in excel

    I get a "runtime error '424' object required"
  11. Zubinsum

    Excel Combo Box Height

    Sounds like your combo box is being sized with the cell it is linked to. If you can delete the old combo box and create a new one, but don't size and move it with the worksheet. (Right click format control, then goto properties.)
  12. Zubinsum

    Updating a combo box's named range in excel

    Hello. I was hoping someone out there could help me with an excel combo box problem I am having. I have a combo box that refers to a named range "x" in excel. I also have a a macro that adds a new cell to that named range ("x") when a user so desires. However, upon...

Part and Inventory Search

Back
Top