Thanks for help . I Make a userform with combobox and make the row source but How do I get the highlight value from my combobox to active cell in excel worksheet automatically. Using Excel 2003.
|
The ControlSource property should store the selected Item on the worksheet.
So for example
RowSource = A1:A10
ControlSource = B1
First Thanks for reply I know that information.
But I need to make the active cell in the active sheet Is The control source for the combobox.
Say Im open my excel file and the combobox is showing
my combobox dragbhavior=2 enabled
I want to
If I select Item From Combobox it will be the active cell value automaticaly
that mean the active cell value = the highlight value in my combobox after selection
my controlsource that i need is The active cell not a detrimine cell Like B1
I think i need to code for that or macro to post value.
thanksComboboxes have a Dragbehavoir property which is either 0 or 1, so not sure what 2 is or does.
| fmDragBehaviorDisabled | 0 | Does not allow a drag-and-drop action (default). |
| fmDragBehaviorEnabled | 1 | Allows a drag-and-drop action. |
If you want to change the ControlSource property you can,
cmbBuMs.ControlSource = Activecell.address
Hey,
Try this…
Private Sub ComboBox1_Change()
ActiveCell.Value = ComboBox1.Value
End Sub
Best Regards
Cathrine
