Results 1 to 2 of 2

Thread: How to obtain the selected value from a combo box in Excel?

  1. Jul 28th, 2005, 03:49 AM #1
    ultra2
    ultra2 is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Posts
    81

    How to obtain the selected value from a combo box in Excel?

    How to obtain the selected value from a combo box in Excel?
    I have a combo box on an excel worksheet, how to write a makro (event handler) to change a cell value as a user choose a number from the combo?

    Sub combo_change()
    Cells(1, 10) = combo_value??
    End Sub

    plz help
    Reply With Quote Reply With Quote
  2. Jul 28th, 2005, 07:50 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: How to obtain the selected value from a combo box in Excel?

    almost
    try combo1.value (rather than underscore)

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    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