ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get value of CheckBox in VBA? (https://www.excelbanter.com/excel-programming/342886-how-get-value-checkbox-vba.html)

mdv

How to get value of CheckBox in VBA?
 

I have a serious problem. I'm trying to create a macro that runs in
certain way if a CheckBox is checked or not. It's just that I have n
idea how to control wether it's True or False. I have tried a whol
bunch of things (I was going to write "everything" but I believe thi
to be possible and hence I have not tried what works...)

I can do this in a private sub, but I want it to work in a "regular
sub in a module. I'd appreciate any suggestions

--
md
-----------------------------------------------------------------------
mdv's Profile: http://www.msusenet.com/member.php?userid=547
View this thread: http://www.msusenet.com/t-187112181


[email protected][_2_]

How to get value of CheckBox in VBA?
 
Is your checkbox from the forms toolbox or from the control toolbox?
Each one behaves very differently...Mark



All times are GMT +1. The time now is 05:14 PM.

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