ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Will Excel create a checkbox? (https://www.excelbanter.com/excel-programming/296078-will-excel-create-checkbox.html)

CherylCGO

Will Excel create a checkbox?
 
I'm a new, thus far self taught MS Excel user.
I'm using Excel to create forms, that take information submitted int
the forms and calculate new values with them.

One thing I feel should be possible, but have been unable to find an
reference to, is to make a check box.

simply a field, that merely clicking on it with your mouse inserts
value. (an X, a check, whatever.. same value everytime)

Is this possible??

On a related note, I am also considering that I may need dropboxe
later..

Thanks in advance for any response

--
Message posted from http://www.ExcelForum.com


Bob Phillips[_6_]

Will Excel create a checkbox?
 
When you look at the userform in VBE you should see a tools dialog, if it
isn't there go to ViewToolbox and click it. You can drag these controls
onto your form then.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CherylCGO " wrote in message
...
I'm a new, thus far self taught MS Excel user.
I'm using Excel to create forms, that take information submitted into
the forms and calculate new values with them.

One thing I feel should be possible, but have been unable to find any
reference to, is to make a check box.

simply a field, that merely clicking on it with your mouse inserts a
value. (an X, a check, whatever.. same value everytime)

Is this possible??

On a related note, I am also considering that I may need dropboxes
later..

Thanks in advance for any response!


---
Message posted from http://www.ExcelForum.com/




CherylCGO[_2_]

Will Excel create a checkbox?
 
I will try that tonight when i get home

--
Message posted from http://www.ExcelForum.com


DNF Karran[_2_]

Will Excel create a checkbox?
 
Forgive me if I have misunderstood but when you go into the VBE an
create a user form, does the "toolbox" menu not popup? If not, go t
"view" then "control toolbox"

If you are making excel forms instead of user forms then in excel
"view", "toolbars", "control toolbox"

You can click and draw a checkbox from these.

The comboboxes are also on the toolbox bar.

Dunca

--
Message posted from http://www.ExcelForum.com


alexvanas[_2_]

Will Excel create a checkbox?
 
hi im alex.
I have the same problem with you.If you find something please tell m
..
I ll do the same..
Cia

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 01:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com