Opening Excel 'Buil-in" Data Entry form using VBA code
Many Thanks to FrancisM for sorting out my previous problem regarding 'Autofilter".
I would like to ask one more question if at all possible, please , as follows:
I have decided to use Excel's built-in' Data Entry form ( works perfectly fine for me), although i cannot use it twice ( in other words ) in two separate sheets within the same workbook. The reason is as follows:
I have inserted a Command button to call out the form as follows:
ActiveSheet.ShowDataForm
and then i was told that i had to create a range named 'Database' on that specific sheet to enable the form to open properly. It works fine, although the problem is:
If I want to use Excel's Data Entry form on another sheet of my current workbook, it will not allow me to create another range named 'Database' again.
Hope i explained myself properly.
Can you please assist ?
Thanking you in advance
Regards
Martin Argimon
|