Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where to place code for change in cell

    I'm definitely not a VBA expert, but I'm trying to automate a workbook with some code. I have two comboboxes placed on an Excel worksheet. The contents of the second combobox depend on the choice in the first. I know how to write the statement that populates the second box, but I don't know where to place it so that it happens as soon as the user makes a choice in the first box.

    The first box is linked to a cell on the sheet, so it could happen as soon as that cell changes, if that's any help!

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where to place code for change in cell

    If you place the comboboxes on the sheet using the Control Toolbox from the View/Toolbars menu, then go into design mode and double click on the first combo box. You should get a VBA editor screen for the combobox change event routine. You can put your code there.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •