Placing cursor in message box
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 |
Placing cursor in message box
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. "Oldjay" wrote: 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 |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com