Web Development

General discussion

Gravatar
0 Votes
Locked

Adding checkbox to Excel sheet

By charu0306 ·
Hi all,
Please clarify whether a control like checkbox can be added to an Excel worksheet at runtime. If yes, how? I want to add a series of checkboxes based on a click of a button. Can someone help? I need it urgently. Thanks and
regards,
Charu.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by josh.asher In reply to Adding checkbox to Excel ...

I don't know of a way to create controls at runtime in VBA, but you can always create all the checkboxes you need, and set their Visible property to false until you want them to be displayed...

gravatar
Collapse -

by theohkm In reply to Adding checkbox to Excel ...

Visual Object creation at runtime is not possible. It is better to put all the required checkboxes into the form and use the .visible property of checkboxes to control the visibility.

You may also want to use "frame" object to contains the checkboxes for better organization.
The approaches simplifies making a set of checkboxes visible/invisible.

gravatar
Collapse -

by charu0306 In reply to

Superb and thanks a lot! I did the same thing in another way using user forms but your answer cleared my doubt.

Thanks again,
Charu.

gravatar
Collapse -

by charu0306 In reply to Adding checkbox to Excel ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums