Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: how to create label forms inside the worksheet not userform
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: how to create label forms inside the worksheet not userform
I'm not sure which Excel version you are using, but go to ToolsInsertForm
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" -- Cheers, Ryan " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: how to create label forms inside the worksheet notuserform
Thanks,
I want to add them in amacro dynamically inside a macro. On Jun 26, 2:58*am, RyanH wrote: I'm not sure which Excel version you are using, but go to ToolsInsertForm 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" -- Cheers, Ryan " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically create a label in a worksheet. | Excel Programming | |||
How do I use a worksheet label to create a formula in Excel 2007? | Excel Discussion (Misc queries) | |||
Dynamic forms in a macro userform | Excel Programming | |||
create a userform to populate a diagram with the forms info | Excel Discussion (Misc queries) | |||
add text to label (label from forms toolbar) | Excel Programming |