VBA & Macros Book Code Sample Yields Error

dognamedboo

New Member
Joined
Jun 4, 2009
Messages
2
I'm using code from the VBA & Macros for Excel 2007 book and pg 255 to populate a userform using an advanced filter to get a unique list. The code hangs up at the line: "With.Me.lbCust". I'm getting an error "Message or Data Member not found". What am I missing?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

EducatedFool

Active Member
Joined
Jun 10, 2009
Messages
272
Re: VBA & Macros Book Code Sample Yeilds Error

Hi
Welcome to the Board

Try:
Code:
With Me.lbCust
 

dognamedboo

New Member
Joined
Jun 4, 2009
Messages
2
Re: VBA & Macros Book Code Sample Yeilds Error

that was my typo - it is as you listed - With Me.lbCust
 

Watch MrExcel Video

Forum statistics

Threads
1,118,662
Messages
5,573,478
Members
412,532
Latest member
crazzyapple
Top