var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Passing ComboBox Name to a Sub
Hi, I have a Form with 10 Comboboxes.
When clicked, I want them to run the same subroutine. However I want to pass the name of the Combo that was clicked on to the subroutine as a String var. Any clues available ?
Thanks up front .....Nick
pass the name as a parameter
say your common subroutine is called
in the combobox on click / on change events
your handler function is somethng like
private function handleClickEvent(strValue as string, optional strComboName as string)
'insert handling code
the optional allows you to omit the strComboName if required
you could extend it by changing the strValue to variant, and eithr expresly tell the handler what datatype to expect
Public Sub yourSub(cboName As String)
Private Sub cboYourCombo_AfterUpdate()
edit: Dang, I need to be quicker on the draw next time...
Thanks to both of you.... sorted :-)