Macro: how to create label forms inside the worksheet not userform

[HammerJoe]

Hi,

I've been searching and all I could find was out to create forms in
userforms.
I would like to create two label boxes in the worksheet.

Can someone shed a light how to create a label form (or a checkbox
form, or text form) in the worksheet?

Thanks

 

[RyanH]

I'm not sure which Excel version you are using, but go to Tools>Insert>Form
Controls. This should get you all the controls you want to add to a
worksheet. Just click the control you want to add and then click and drag on
the worksheet.

I hope this helps! If so, please Click "Yes"

 

[HammerJoe]

Thanks,

I want to add them in amacro dynamically inside a macro.