Input box

[Oldjay]

Screwed up my first question. Here is the correct question

I have the following code

quotenumber = InputBox("Please enter QUOTE number to recall , "The Auld
Company", "C:\Quick Quotes3\")
QUOTE = quotenumber & ".XLS"

As shown it highlights " C:\Quick Quotes3\" in the input box. I want it to
place the cursor at the end of C:\Quick Quotes3\

oldjay

 

[fredg]

Screwed up my first question. Here is the correct question

I have the following code

quotenumber = InputBox("Please enter QUOTE number to recall , "The Auld
Company", "C:\Quick Quotes3\")
QUOTE = quotenumber & ".XLS"

As shown it highlights " C:\Quick Quotes3\" in the input box. I want it to
place the cursor at the end of C:\Quick Quotes3\

oldjay

That's not how to do it.
As "C:\Quick Quotes3\" is always used, try:

quotenumber = InputBox("Please enter QUOTE number to recall , "The
Auld Company")
QUOTE = "C:\Quick Quotes3\" & quotenumber & ".XLS"