Advertisement

06.21.2007 at 08:49AM PDT, ID: 22648918
[x]
Attachment Details

Excel VBA help, input box with two values and storing inputs to variables

Asked by collages in Business Objects, Visual Basic Programming, Microsoft Excel Spreadsheet Software

Tags: vba, excel, input, box

I am helping to automate a process where a user performs a find/replace on approximately 30 worksheets.  On each worksheet it is the exact same find value and the exact same replace value.

I want to present the user with a single input box where they can exter the find/replace values.  Then, I am looking to store these values to a variable and then call the find/replace function for each worksheet.

What would be helpful would be the code for:

1.  The input box with 2 values
2.  Code to store the values to variables

Thanks!Start Free Trial
[+][-]06.21.2007 at 08:54AM PDT, ID: 19334240

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Business Objects, Visual Basic Programming, Microsoft Excel Spreadsheet Software
Tags: vba, excel, input, box
Sign Up Now!
Solution Provided By: ture
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.21.2007 at 08:56AM PDT, ID: 19334258

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.21.2007 at 08:58AM PDT, ID: 19334286

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.21.2007 at 08:58AM PDT, ID: 19334291

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.21.2007 at 09:01AM PDT, ID: 19334321

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.21.2007 at 09:02AM PDT, ID: 19334335

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.21.2007 at 09:08AM PDT, ID: 19334411

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32