Inputbox vs. Application.InputBox

[miyachow]

Please Login or Register  to view this content.

Above is my code, basically what I did was prompting an inputbox to let user enter its changing cells and then run the solver.
Now I want user to select instead of enter cells in inputbox, hence I used Application.InputBox

Please Login or Register  to view this content.

however, I couldn't run the solver if I changed to application.inputbox, does anyone know is there any problem with the code?

Thanks!!!

[TMS]

In the first example, you are inputting a string which represents a range address.

In the second example you are actually setting x equal to a range.

Try:

Please Login or Register  to view this content.

Or, you might get away with:

Please Login or Register  to view this content.

Regards, TMS

[ragulduy]

Well your second inputbox will return x as a range object and the first will return a string. Presumably ByChange needs to be a string so try using:

Please Login or Register  to view this content.

Edit: @TMS - beat me to it but you need to remove the set command when setting x equal to the application.inputbox address

[TMS]

@yudlugar: good spot ... that was what I intended

Fixed now

[miyachow]

Hey guys,

it works well!! thank you so much!

[TMS]

You're welcome.