Would like to locate a text box based on a search string and copy

J

Jeffy

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.
 
R

Rich Locus

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Custom toolbar button for search and replace 1
WORD VBA Search and switch to advanced ... 1
How to disable synchronization of text boxes. 0
Word macro that can call cells out of Excel for a find and replace 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top