hi mRice, royUK,
It's still not working.
First, to include columns and column headings, I did the following:
1. Inserted a listbox control (Form Control) from the tool box into the worksheet.
2. Changed the name in the name box to 'myList'
3. Selected 'Properties' option on the toolbar, and inserted the range into the 'Input Range' option in the Control tab.
4. After that, in the VBE, I entered the following code:
The above generated the following error on activating the worksheet:
Run-time error '438':
Object doesn't support this property or method
Then, I tried the following:
1. Inserted a module, and inserted the following sub -
2. Right-clicked on the listbox in the worksheet and selected 'Assign Macro' and selected 'myList_Click'.
On clicking, the following error was generated:
Run-time error '1004':
Method 'OLEObjects' of object '_Worksheet' failed
What is so wrong that I am doing?
Bookmarks