inputbox
 

here is the first part of my code:
Function base()
Dim baseinput As String
baseinput = InputBox("Base?")
If myinput = "panel" Then
Application.Run "panel"

This is case sensitive, how can i change that?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

inputbox
 

baseinput = LCase(InputBox("Base?"))
--
Gary's Student
gsnu200705


"brownti via OfficeKB.com" wrote:

here is the first part of my code:
Function base()
Dim baseinput As String
baseinput = InputBox("Base?")
If myinput = "panel" Then
Application.Run "panel"

This is case sensitive, how can i change that?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

inputbox
 

perfect, thanks.



Gary''s Student wrote:
baseinput = LCase(InputBox("Base?"))
here is the first part of my code:
Function base()
[quoted text clipped - 4 lines]

This is case sensitive, how can i change that?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1