Set Property with user input w/o Case or ElseIf

Topic

New Reply

My macro gives gives the user the option to export a Excel 97 worksheet range according to his/her needs using these properties:
Cells(r,c).Value
Cells(r,c).Text
Cells(r,c).Formula

Q: How can I make the VBA/Excel 97 interpreter to accept something like this:

DoItMyWay=Inputbox(“How do you want it ? Value, Text, Formula ?”,”Value”)
.
.
XYZ=Cells(r,c).DoItMyWay

I could do this using Case or ElseIf, but I wonder whether I can do this directly with a one liner.

Reply | Quote

Replies

calacuccia, thanks, but this really would be overkill. I am only trying to reduce the number of similar calls. I thought this should be easily possible, VBA being an interpreted language.

Reply | Quote