Results 1 to 2 of 2

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

  1. Jul 28th, 2005, 04:54 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, 04:58 AM #2
    penagate
    penagate is offline
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

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

    Cells(1,10) = combo.Text
    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