Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I "set" a checkbox name like i Set a worksheet?
Hi JustChris, I tried your code and it works real nice. This is what I tried: Private Sub CommandButton1_Click() Dim checknum As Integer Dim blahblah As Integer If TextBox1 = 1 Then checknum = 1 End If If TextBox1 = 2 Then checknum = 2 End If Call checkbox_num(checknum) End Sub Sub checkbox_num(checknum) Dim chckbox As Object Set chckbox = UserForm3.Controls("checkbox" & checknum) chckbox.Value = True End Sub Are you encountering any problems with this method - Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=373048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"_Fill" and "_Key1" is contained in the worksheet I want to copy.. | Excel Discussion (Misc queries) | |||
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Excel VBA - go to worksheet "name" based on a cell reference ="Name" | Excel Programming |