Unable to paste cell value in input box while triggering VBA script

[ravi123]

Hi All,

I'm having a vba script wherein a pdf is being generated by providing account number through input box.
I'm coping a cell value (account number), triggering the vba script through keyboard shortcut, a input box appear and now I'm supposed to paste that copied cell value into input box, however it's not getting pasted. But if I paste cell value in sticky note or in notepad, and then again copy that, come back to script file, trigger the code and paste in input box and it's done.


Data (account number and other info) and VBA script is in same file.


Want to know what I'm doing wrong in first case. Why cell value is not getting pasted in input box straight from the script file? Is there a some sort of limitation or something else. In second senerio, code is working like charm.
Please help.

 

[Yongle]

You could use a variable to hold the value, something like this ...

Dim X As String, IBox as string
X = YourCell.Value
IBox = InputBox( "Mesage Text", "Title Text", X)