Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Help! Refrence a userform element from a textbox?

I'm trying to figure out how to refrence a userform element (a
checkbox -- say checkbox1) from a textbox.

When checkbox1 is press it is disabled.

The words "checkbox1" are entered into a textbox (say textbox1).

I have a standard command button I'd like to press to allow for the
variable of "checkbox1" to become enabled by just pressing it.

I have 60 diffrent checkboxes and based on what once is pressed will
enter it's own value in textbox1 -- I can figure out that part but I
can't figure out how to tell VBA to use the value of textbox1 as a
form variable...

Private Sub CommandButton1_click()
Dim LOCK1 as String
TextBox1.value = LOCK1
LOCK1.Enabled
End Sub

Any ideas would be greatly appreciated! Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Userform Textbox help Joey_83 Excel Programming 1 September 11th 07 09:14 AM
Userform textbox help [email protected] Excel Programming 1 September 17th 06 08:27 AM
Textbox in userform Harald Staff Excel Programming 0 September 8th 04 11:51 AM
Textbox in userform shaharul[_6_] Excel Programming 3 April 15th 04 12:54 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"