Hi all
I have multiple spinners (8) on a layout and I have specified a single Sub (spnL1A1) in "Event Name" in the designer to handle all their events.
In my Sub spnL1A1, how would I get the value of the selected item and assign it to its local variable - taking in to account there are 8?
For example, in pseudo code it would be:
Sub spnL1A1
'Get the value of the spinner clicked
Select
Case Spinner1
variable1 = spinner1.value
Case Spinner2
variable2 = spinner2.value
End Select
End Sub
etc.
Thanks
I have multiple spinners (8) on a layout and I have specified a single Sub (spnL1A1) in "Event Name" in the designer to handle all their events.
In my Sub spnL1A1, how would I get the value of the selected item and assign it to its local variable - taking in to account there are 8?
For example, in pseudo code it would be:
Sub spnL1A1
'Get the value of the spinner clicked
Select
Case Spinner1
variable1 = spinner1.value
Case Spinner2
variable2 = spinner2.value
End Select
End Sub
etc.
Thanks