Results 1 to 2 of 2

Thread: ComboBox

  1. Apr 1st, 2004, 03:23 AM #1
    Greyskull
    Greyskull is offline

    Thread Starter
    Hyperactive Member Greyskull's Avatar
    Join Date
    Dec 2003
    Location
    somewhere in England
    Posts
    382

    Question ComboBox

    Is it possible to automatically update a combobox whenever a new item is added in a range in excel?

    Thanx in advance,

    Greyskull
    Reply With Quote Reply With Quote
  2. Apr 1st, 2004, 04:33 PM #2
    TheFIDDLER
    TheFIDDLER is offline
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126
    You can use the Sub Workbook_SheetSelectionChange event to respond to changes done on a worksheet. Your code could look at where the data was entered, and if in a given range, add the item to your combobox.
    -----
    #VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP

    I miss my VIC 20.
    Never should have upgraded to my commodore 64. ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width