Inputbox default Question

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
 
P

PCLIVE

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
 
L

Les Stout

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

Best regards,

Les Stout
 
G

Guest

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.
 

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

Top