Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check control names
I would like to be able to run a code that will check to see if a
control has a particular name and then tell me which one has that name. I thought the code below would work but it does not do the trick. Private Sub btnSubmit_Click() Dim C As Control For Each C In Me.Controls If C.Name = "txtnum1" Then MsgBox C.Name End If Next C End Sub Additionally is there a way to use a wild card. For example show me all textboxes that start with txtNum (txtNum1, txtNum2, etc) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check control names
It worked ok for me.
Maybe you need: if lcase(c.name) = "txtnum1" then stewart wrote: I would like to be able to run a code that will check to see if a control has a particular name and then tell me which one has that name. I thought the code below would work but it does not do the trick. Private Sub btnSubmit_Click() Dim C As Control For Each C In Me.Controls If C.Name = "txtnum1" Then MsgBox C.Name End If Next C End Sub Additionally is there a way to use a wild card. For example show me all textboxes that start with txtNum (txtNum1, txtNum2, etc) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
check control names
On Sep 13, 8:55 pm, Dave Peterson wrote:
It worked ok for me. Maybe you need: if lcase(c.name) = "txtnum1" then stewart wrote: I would like to be able to run a code that will check to see if a control has a particular name and then tell me which one has that name. I thought the code below would work but it does not do the trick. Private Sub btnSubmit_Click() Dim C As Control For Each C In Me.Controls If C.Name = "txtnum1" Then MsgBox C.Name End If Next C End Sub Additionally is there a way to use a wild card. For example show me all textboxes that start with txtNum (txtNum1, txtNum2, etc) -- Dave Peterson that did the trick...now is there a way to change that so i can search for a wildcard. i want to find all textboxes that begin with txtNum |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
check control names
One way is to just look at the leftmost 6 chars:
if left(lcase(c.name),6) = "txtnum" then stewart wrote: On Sep 13, 8:55 pm, Dave Peterson wrote: It worked ok for me. Maybe you need: if lcase(c.name) = "txtnum1" then stewart wrote: I would like to be able to run a code that will check to see if a control has a particular name and then tell me which one has that name. I thought the code below would work but it does not do the trick. Private Sub btnSubmit_Click() Dim C As Control For Each C In Me.Controls If C.Name = "txtnum1" Then MsgBox C.Name End If Next C End Sub Additionally is there a way to use a wild card. For example show me all textboxes that start with txtNum (txtNum1, txtNum2, etc) -- Dave Peterson that did the trick...now is there a way to change that so i can search for a wildcard. i want to find all textboxes that begin with txtNum -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
check control names
On Sep 13, 9:38 pm, Dave Peterson wrote:
One way is to just look at the leftmost 6 chars: if left(lcase(c.name),6) = "txtnum" then stewart wrote: On Sep 13, 8:55 pm, Dave Peterson wrote: It worked ok for me. Maybe you need: if lcase(c.name) = "txtnum1" then stewart wrote: I would like to be able to run a code that will check to see if a control has a particular name and then tell me which one has that name. I thought the code below would work but it does not do the trick. Private Sub btnSubmit_Click() Dim C As Control For Each C In Me.Controls If C.Name = "txtnum1" Then MsgBox C.Name End If Next C End Sub Additionally is there a way to use a wild card. For example show me all textboxes that start with txtNum (txtNum1, txtNum2, etc) -- Dave Peterson that did the trick...now is there a way to change that so i can search for a wildcard. i want to find all textboxes that begin with txtNum -- Dave Peterson thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a control check box to control other checkboxes? | Excel Worksheet Functions | |||
Check Box Control | Excel Programming | |||
Control Names | Excel Programming | |||
Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) | |||
Check box control | Excel Programming |