Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i find the text box number?
I'm working on some vba for a friend and between saving, resaving, and
changing, my code busts in the fact that it's looking for Text Box # and can't find it. My code is looking for TextBox 1 and can't find it. I know which box it is and I wanted to check to see if the box number has changed. How do I find that out? Does this make sense? I tried recording a new macro where I move the box around or edit it, but MS07 didn't show me the text box # in the recorded macro. Is there some properties or something I can look at that shows me what the identifier is of the text box? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i find the text box number?
Hi,
open visual basic and click in view object, then position in the textbox you are looking for, at your left the properties will give you the textbox # If this was helpful please say yes, thank you "gab1972" wrote: I'm working on some vba for a friend and between saving, resaving, and changing, my code busts in the fact that it's looking for Text Box # and can't find it. My code is looking for TextBox 1 and can't find it. I know which box it is and I wanted to check to see if the box number has changed. How do I find that out? Does this make sense? I tried recording a new macro where I move the box around or edit it, but MS07 didn't show me the text box # in the recorded macro. Is there some properties or something I can look at that shows me what the identifier is of the text box? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i find the text box number?
On Dec 23, 9:00*am, Eduardo wrote:
Hi, open visual basic and click in view object, then position in the textbox you are looking for, at your left the properties will give you the textbox # If this was helpful please say yes, thank you "gab1972" wrote: I'm working on some vba for a friend and between saving, resaving, and changing, my code busts in the fact that it's looking for Text Box # and can't find it. *My code is looking for TextBox 1 and can't find it. *I know which box it is and I wanted to check to see if the box number has changed. *How do I find that out? *Does this make sense? I tried recording a new macro where I move the box around or edit it, but MS07 didn't show me the text box # in the recorded macro. *Is there some properties or something I can look at that shows me what the identifier is of the text box? Thanks Yes, thank you. Actually, I was just about to reply back to myself and say nevermind. Although, I didn't know how to do it in VB. But if you click the box in excel, the Name Box attribute tells you the box number just as it tells you what cell you're in when you click a cell. Thanks though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text Sequentially Number | Excel Programming | |||
find % number from text string | Excel Discussion (Misc queries) | |||
Find and Add a number in a text field | Excel Worksheet Functions | |||
how do i use VLOOKUP to find text and return a number? | Excel Discussion (Misc queries) | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming |