Results 1 to 2 of 2

Thread: Excel ComboBox Results to another cell?

  1. Oct 27th, 2011, 02:36 PM #1
    Art W.
    Art W. is offline

    Thread Starter
    Hyperactive Member Art W.'s Avatar
    Join Date
    Apr 2002
    Location
    In My Own Little World, But that’s OK because they know me there!
    Posts
    271

    Excel ComboBox Results to another cell?

    Hello Everyone:

    I am trying to get a selected option from an Active X Control ComboBox to appear in another cell.

    If you select answer “A(or B,C,D…)” in the combobox in sheet one, how can I get the “A(or B,C,D…)” to appear in cell C3 in sheet2?

    Any Ideas?

    Thanks

    Art W.
    SLEEP: A Totally Inadequate Substation For Caffeine!
    Reply With Quote Reply With Quote
  2. Oct 27th, 2011, 11:55 PM #2
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Re: Excel ComboBox Results to another cell?

    Is this a combobox from a userform in excel?
    Where is the code for that control, in this Excel-File, in a module,....

    Within the change-event of that combobox something like
    Code:
    Thisworkbook.Sheets(YourSheetIndex).Cells(3,3).Value=YourComboBox.List(Yourcombobox.ListIndex)
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    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