Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pupop
-
Reference the value of a control by the controls name
That is a good point!, but in the application I am working on the control names I am passing to this function are all ComboBoxs- pupop
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Reference the value of a control by the controls name
The following code is what I am using now, it is very inefficient but it gets the job done. Function strGetValue(strName as string) as string dim intCount as integer intCount = me.controls.count strGetValue = "" do while intCount > 0 intCount = intCount - 1 if me.controls(intCount).name =...- pupop
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Reference the value of a control by the controls name
Is there a simple way to dynamicly reference the value in a control on a form if all I know is the name of the control? this doesn't work: me.controls(strControlName).value I want to do something like this: sub doSomething(strControlName as string) if me.controls(strControlName).value > 50...- pupop
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
