Input box

  • Thread starter Thread starter Oldjay
  • Start date Start date
O

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
 
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
Click to expand...

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"
 
Back
Top