Inputbox default Question

  • Thread starter Thread starter Les Stout
  • Start date Start date
L

Les Stout

Hi all, when one makes a default for an input box e.g.
myInv = InputBox("PLease enter the number of the invoice to delete...",
"DELETE INVOICE", "024908")

When the dialog box opens the default "024908" is highlited and if the
user just types, it is deleted and written over, is there a way to
prevent this so that when they start typing it is after the 8 ??

Best regards,

Les Stout
 
What purpose does the "024908" serve?
You could make the default number invisible to the user.

myInv = "024908" & InputBox("PLease enter the number of the invoice to
delete...","DELETE INVOICE)

HTH,
Paul
 
Will probably take your advice and make it invisable thanks Paul...

Best regards,

Les Stout
 
I don't think there is a way in which you can set the cursor etc.
The best option according to me is to use a userform with a text box. The
user form will give you more flexibility as well.
 
Back
Top