Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Would like to locate a text box based on a search string and copy
I have a worksheet with several text boxes on it. Based on a radio button
selection I need to search through all of the text boxes for for a text string and display that box on the worksheet where the radio button is or copy it based on some reference. I use text boxes from the Draw toolbar because they are highly formatable. Another method may be acceptable as long as I can format text. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Would like to locate a text box based on a search string and copy
Hello:
Can I assume that your Textboxes are on a regular worksheet and not a form opened with the VBA command MyForm.Show? Also, which toolbox did you use: Forms or Control Toolbox? Depending on the answers, the methods are different. -- Rich Locus Logicwurks, LLC "Jeffy" wrote: I have a worksheet with several text boxes on it. Based on a radio button selection I need to search through all of the text boxes for for a text string and display that box on the worksheet where the radio button is or copy it based on some reference. I use text boxes from the Draw toolbar because they are highly formatable. Another method may be acceptable as long as I can format text. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to locate and validate specific text from a string | Excel Discussion (Misc queries) | |||
How to search Excel files based on a specific text string in VBA c | Excel Discussion (Misc queries) | |||
Search text string for ssn and copy to new column | Excel Discussion (Misc queries) | |||
Locate and count the recurrences of a text string | Excel Discussion (Misc queries) | |||
Using IF to locate specific text string value | Excel Programming |