Call Sub From InputBox

[John Cole, Jr.]

I have written a macro that will loop through every workbook in a
certain directory. I would like to use that for several other macros
that will do things in the workbooks. Is there a way, I can use an
InputBox to call the routine/sub I want to run with the Loop
procedure?

Thanks in Advance,

JC

 

[Don Guillett]

how about
call inputbox("Enter sub to call")

 

[John Cole, Jr.]

how about
call inputbox("Enter sub to call")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)






- Show quoted text -

Tried that, and I got an error.

JC

 

[Guest]

Use the brute force approach

Add string names for the function in the test box like
Function1 Function2 Function3

then read input box
FunctionName = inputbox.text

then use a select function to do the call

select case Function Name
Case "Function 1"
call Function1
Case "Function 2"
call Function2
Case "Function 3"
call Function3
end Select

 

[Dave Peterson]

application.run YourMacroNameVariableHere
(No checking at all!)

But I wouldn't do this. I'd give the user (including me!) a way to run the
procedure that I wanted.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

 

[Don Guillett]

Sorry. try this
Application.Run InputBox("Enter sub to call")

 

[John Cole, Jr.]

Sorry. try this
Application.Run InputBox("Enter sub to call")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)






- Show quoted text -

....Like a charm.
Thanks a lot!

JC