Convert Code from using Userbox to Userform

Hi all,

I'm trying to convert some code to run from a userbox to run from a userform
So far everything that I've tried I'm getting an error for something.

Directly below is the code I'm running initally.
(Good code )

Please Login or Register  to view this content.

This is the codec coverted code that failing and I have yet to get it to work.

Please Login or Register  to view this content.

the following give a "mismatch" error

Please Login or Register  to view this content.

The following changes tell me an object is required.

Please Login or Register  to view this content.

If anyone can correct this that would be great.

Thanks,

BDB

I need to somehow change the String value to a Range value.

I've tried this but is doesn't work either.

Please Login or Register  to view this content.

I don't know why this is so difficult.
What's the difference of using a selected range placed into a userbox(Application.InputBox) differ from a userform (UserForm1.RefEdit1.Text)?
Raddress = Application.InputBox vs Raddress = UserForm1.RefEdit1.Text ???

BDB

Try this:

Please Login or Register  to view this content.

What's a usebox?

Can you edit the Title please