Using inputBox to assign multiple variables and then assigning
the info from those variables to cells which I then reference from
another macro.

What I'm finding is that as already noted here in another thread:

"There is another Inputbox function in VBA which returns an empt
string if cancel is pressed."

This is what seems to be happening if I hit either 'Cancel'
or 'Enter'.

What I'd like to do, is afford the user the opportunity to change
not all or lose all, but to be able to change just some of the
information.

Is there a way with multiple variables to change just some of
the variables but not all without erasing previously entere
information by hitting 'cancel' or 'enter'?

Thanx

--
Message posted from http://www.ExcelForum.com

An input box is generally used for one entry. It is unclear how you are
populating several variables with the results of a single inputbox or how
you would adapt this to allow the user to edit a subset of those entries.

--
Regards,
Tom Ogilvy

"spurtniq" wrote in message
...
Using inputBox to assign multiple variables and then assigning
the info from those variables to cells which I then reference from
another macro.

What I'm finding is that as already noted here in another thread:

"There is another Inputbox function in VBA which returns an empty
string if cancel is pressed."

This is what seems to be happening if I hit either 'Cancel'
or 'Enter'.

What I'd like to do, is afford the user the opportunity to change
not all or lose all, but to be able to change just some of the
information.

Is there a way with multiple variables to change just some of
the variables but not all without erasing previously entered
information by hitting 'cancel' or 'enter'?

Thanx.


---
Message posted from http://www.ExcelForum.com/