macro attached to command button - VBA form
 

Hi

Can I attach a previously contrsucted Macro to a new cmd button placed on a
VBA user form ?

If so how ?
--
thanks
Roy

macro attached to command button - VBA form
 

Try calling that macro as below

Private Sub CommandButton1_Click()
Call Macroname
End Sub

--
Jacob


"Roy Gudgeon" wrote:

Hi

Can I attach a previously contrsucted Macro to a new cmd button placed on a
VBA user form ?

If so how ?
--
thanks
Roy

macro attached to command button - VBA form
 

Hi Jacon

So easy, I'llget the hang of this eventually !

Got small problem with Macro but I'll sort that


--
thanks
Roy


"Jacob Skaria" wrote:

Try calling that macro as below

Private Sub CommandButton1_Click()
Call Macroname
End Sub

--
Jacob


"Roy Gudgeon" wrote:

Hi

Can I attach a previously contrsucted Macro to a new cmd button placed on a
VBA user form ?

If so how ?
--
thanks
Roy