Text in a dialogue box

[Hanys]

My macro shows a dialogue box ("the box") awaiting user's input of a text string. There's a default text in the box already. I want to run (using the keyboard arrows, Home, End keys) through the characters of the default text in the box, to modify the text. However, this results in a spreadsheet range being automatically inserted within the text in the box.
How to prevent that a spreadsheet range is automatically inserted within the text in the box when I use keyboard arrow keys?

[6StringJazzer]

I would not expect that to happen. Is the dialog box a UserForm that you built, or a built-in Excel dialog? What action is causing the dialog box to be displayed? Can you attach your file?

The paper clip icon does not work for file attachments. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[MarvinP]

Hi Hanys and welcome to the forum,

If you are using VBA and an InputBox then look at this site to see how to set the default value that goes in the box.

https://msdn.microsoft.com/en-us/vba...x-method-excel

[Hanys]

Hi 6StringJazzer,

Please use the following example code to see my problem:

Please Login or Register  to view this content.

After running the code don't press OK or Cancel in the dialogue box.
Press left/right arrow key on the keyboard, or Home/End key.
The word "Something" will change into a cell reference, e.g. "=$A$1",
depending which cell of the spreadsheet was selected before running the macro.
(At least this is what is happening in my spreadsheet.)

I would like to use left/right arrow keys of the keyboard to run through
the text "Something", and change it by typing, without grabbing the mouse and
without deleting it.

How to prevent cell reference appearing in the text field when I use arrow keys?

Hanys

[Norie]

Try using InputBox instead of Application.InputBox.

[Hanys]

Norie,
It was that simple.
Thank you.
Hanys

[xlnitwit]

Pressing f2 should toggle between input and edit mode with the original code.

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer