Copy entire row based on message box asking which row number to copy?

[JDI]

Hello,
Using vba I'd like a floating text box which when I enter the row number copies the entire row to a new sheet. Ideas?

Thanks,
JDI

[pjwhitfield]

Please Login or Register  to view this content.

Not got acess to VBA here so maybe 1 or 2 errors in the above but the gist is there.

[zbor]

Try this:

Please Login or Register  to view this content.

[JDI]

Hmm, a message box comes up and I type in the row number however, no copy takes place. The values "1:1" should remain unchanged correct, that is essentially telling it to copy a single row. I am trying to copy data from a sheet called Raw Data to a sheet called Search_Results. Also do you happen to know how to make a form control float?

Thanks very much,
JDI

Try this:

Please Login or Register  to view this content.