Prity
02-20-2015, 05:20 AM
Hi All,
i have code for the combobox(i have added this for the data validated cells only) in the Worksheet_selection() event.
When ever i click on the combobox - it shows all the list of values present in it.
Now every time i select any value from the combo box, it should show some relevent values in other cells of column H and N, i have written the code for this in a function. But from where to call it, how to make it working? i am not getting it...
step1:
code is in:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
code for combobox,
when u select the combo box it shows list of values.
end sub
where shall i make this function call - Call ComputeRate(ActiveCell.Value, Cells(ActiveCell.Row(), 2).Value)
this function contains - for every value user selects , it puts the corresponding values in to the cells of Column 'N' n H
So please help me out.
Regards
Seema
i have code for the combobox(i have added this for the data validated cells only) in the Worksheet_selection() event.
When ever i click on the combobox - it shows all the list of values present in it.
Now every time i select any value from the combo box, it should show some relevent values in other cells of column H and N, i have written the code for this in a function. But from where to call it, how to make it working? i am not getting it...
step1:
code is in:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
code for combobox,
when u select the combo box it shows list of values.
end sub
where shall i make this function call - Call ComputeRate(ActiveCell.Value, Cells(ActiveCell.Row(), 2).Value)
this function contains - for every value user selects , it puts the corresponding values in to the cells of Column 'N' n H
So please help me out.
Regards
Seema