Question about Inputbox Appearance

[frank_AL]

I have code that prompts the user for current month using Inbox. I pre-populate that field before calling the code. The issue I'm having is that Inbox displays are rather small (don't want to create a UserForm!) and the pre-populated number is highlighted which make it harder to read, see image below. Is there a way to change that to where the number '9' is not highlighted?

Let me know, thanks!

 

[iggydarsa]

Unfortunately this is how the inputboxes are designed, to make it easier for the user to avoid extra step of erasing the default value. I know you dont want to create it but I think UserForm seems to be the only option.

 

[dmt32]

Is there a way to change that to where the number '9' is not highlighted?

Hi
you have not shared your code but using SendKeys with the InputBox Function hopefully, should move cursor to the end doing what you want - maybe?

     ReportMonth = Month(Date)

    SendKeys "{END}"
    report = InputBox("Enter Current Report Month (Numeric)", "Report Month", ReportMonth)

'rest of code

Dave

 

[frank_AL]

Dave,
The concept of your reply makes sense. However, I've tried several different ways to integrate SendKey with the InputBox to no avail. I guess I need to create a UserForm. Thanks for your reply.

 

[dmt32]

Dave,
The concept of your reply makes sense. However, I've tried several different ways to integrate SendKey with the InputBox to no avail. I guess I need to create a UserForm. Thanks for your reply.

As said, as you never shared any code so I just created an example - concept normally works ok in other applications I have assisted with but perhaps not for your requirement.

Appreciate your feedback

Dave