jam03
09-25-2008, 09:21 AM
Hi guys,
I've been using quite a lot of "Application.InputBox" to set ranges in order to make my macros as flexible as possible, since i'm using them for different files. And i like being able to select the ranges with the mouse since a lot of the people who are using my macros don't know much about excel.
I do encounter a little problem though! :banghead: When using different workbooks at the same time, you can't actually switch workbook and select with the mouse ranges in this other workbook... :reading:
So I wanted to know if there was a way to make this possible, to call the same kind of value box as the ones in the "Conditional Formatting facility" where you can select values ranges in other workbooks easily.
Thanks in advance,
Best Regards,
Mateo
I've been using quite a lot of "Application.InputBox" to set ranges in order to make my macros as flexible as possible, since i'm using them for different files. And i like being able to select the ranges with the mouse since a lot of the people who are using my macros don't know much about excel.
I do encounter a little problem though! :banghead: When using different workbooks at the same time, you can't actually switch workbook and select with the mouse ranges in this other workbook... :reading:
So I wanted to know if there was a way to make this possible, to call the same kind of value box as the ones in the "Conditional Formatting facility" where you can select values ranges in other workbooks easily.
Thanks in advance,
Best Regards,
Mateo