Reading values from inputbox into arrays
Is it possible to read the values from inputbox directly into arrays?
The values may be comma-separated or space-separated.
The initial problem is I want to exclude certain sheets from
processing based on user's input. So I display the msg showing all the
sheet names to the user and if the user chooses to exclude some of the
sheets, I plan to ask for the sheet names to be excluded which I plan
to put in an array and use the array for further processing.
Thanks
|