How to reference a vba chkbox from a vba command button on excel?
Hi,
I have a vba command button and checkbox on an excel spreadsheet. How can I reference the chkbox from the click event of the command button. I would like to turn it on and off from the click event of the command button. Both are from the vba toolbox and both are directly on the spreadsheet and not on a vb form. I don't know if this is possible but if it is it would be very helpful to me thanks' Sterl |
How to reference a vba chkbox from a vba command button on excel?
Something like:
Option Explicit Private Sub CommandButton1_Click() If Me.CheckBox1.Value = True Then MsgBox "It's checked" Else MsgBox "It's not checked" End If End Sub Change the names to match your buttons and checkboxes. Sterl wrote: Hi, I have a vba command button and checkbox on an excel spreadsheet. How can I reference the chkbox from the click event of the command button. I would like to turn it on and off from the click event of the command button. Both are from the vba toolbox and both are directly on the spreadsheet and not on a vb form. I don't know if this is possible but if it is it would be very helpful to me thanks' Sterl -- Dave Peterson |
How to reference a vba chkbox from a vba command button on excel?
Hi Sterl,
Try something like: '============= Private Sub CommandButton1_Click() With Me.CheckBox1 .Value = Not .Value End With End Sub '<<============= --- Regards, Norman "Sterl" wrote in message ups.com... Hi, I have a vba command button and checkbox on an excel spreadsheet. How can I reference the chkbox from the click event of the command button. I would like to turn it on and off from the click event of the command button. Both are from the vba toolbox and both are directly on the spreadsheet and not on a vb form. I don't know if this is possible but if it is it would be very helpful to me thanks' Sterl |
How to reference a vba chkbox from a vba command button on excel?
Hi Dave,
Your suggestion worked fine...didn't know about the Me...I'm a bit new at this. thanks, Sterl Sterl wrote: Hi, I have a vba command button and checkbox on an excel spreadsheet. How can I reference the chkbox from the click event of the command button. I would like to turn it on and off from the click event of the command button. Both are from the vba toolbox and both are directly on the spreadsheet and not on a vb form. I don't know if this is possible but if it is it would be very helpful to me thanks' Sterl |
How to reference a vba chkbox from a vba command button on excel?
Hi Norman,
I tried your solution and it worked fine. I also then tried to do the same from a vba form to get the same chkbox but instead of Me I used with ActiveSheet and it worked fine too. Thanks for the idea, Sterl Norman Jones wrote: Hi Sterl, Try something like: '============= Private Sub CommandButton1_Click() With Me.CheckBox1 .Value = Not .Value End With End Sub '<<============= --- Regards, Norman "Sterl" wrote in message ups.com... Hi, I have a vba command button and checkbox on an excel spreadsheet. How can I reference the chkbox from the click event of the command button. I would like to turn it on and off from the click event of the command button. Both are from the vba toolbox and both are directly on the spreadsheet and not on a vb form. I don't know if this is possible but if it is it would be very helpful to me thanks' Sterl |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com