Placing cursor in message box

O

Oldjay

I have the following code

quotenumber = InputBox("Please enter QUOTE number to recall from your hard
drive. If recalling a quote from the server type in
\\server3\jobs\estimate1\quick quotes3\ and the estimate number ", "The
Company", "C:\Quick Quotes3\")
QUOTE = quotenumber & ".XLS"

As shown it highlites the quote number .xls. I want it to place the curcor
at the .xls

oldjay
 
J

JR Form

Oljay,

If the quotes are stored in a specific directory then don't give the user
the chance to change the directory. You can just tie together the variables
as you did with Quotenumber and "xls". You would have an issue if the
directory "quick quotes 3" is not on the machine, however, you can run code
to test for it and/or create it. On the server you may want to have the user
type the word "server" and then the quote number. You can test your variable
for the word "server" then use the path '\\server3\jobs\estimate1\quick
quotes3\' + quotenumber to locate the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

On Error 6
Ehandler 1
ehandler 2
Input box 1
Input box 7
Finding a file 6
Creating a path to save a file 5
Identifying drive letter with Save-as to a server 4

Top