how to link commandbuttons on userform

**cfinch100** · 03-29-2013, 04:35 PM

hi
can commandbuttons be linked together to run a few with one click,i did commandbutton1_click,commandbutton2_click,commandbutton3_click,but this adds an extra line at the end of the sheet,it runs a combobox and textboxes can it be made to say if combobox is empty then exit
cheers colin

**Norie** · 03-29-2013, 04:39 PM

Colin

You could just move the code for all the command buttons into a separate sub and call that.

It's easy to check if a combobox is empty and exit if it is.

Please Login or Register  to view this content.

**cfinch100** · 03-29-2013, 05:13 PM

hi norie
code has simalar to this do i need to swap this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

cheers colin

**Norie** · 03-29-2013, 06:34 PM

Not sure what your asking.

**cfinch100** · 03-29-2013, 10:49 PM

hi
the code you gave me would i swap with this one in mine or add another line

Please Login or Register  to view this content.

sorry prob did not explain properly
cheers colin

**Norie** · 03-30-2013, 12:13 PM

Colin

You shouldn't need to change anything.

In the original code if ListIndex is -1 all the code in the If..End If block will be skipped.

The next line of code after that block is End Sub...