I see the answer to my problem!! on the printout of the code you gave
me. I used A1:C333 for MyDataRange where I think I was supposed to use
A1:A333 - correct?<<

A+, Joanne! Absolutely, correct. The MyDataRange refers to a single column
of cells. Nice job figuring out the issue.

Let me know if I can help any more with your listbox issues.
(and...I'll looking for your next posts.)

***********
Regards,
Ron

XL2002, WinXP


"Joanne" wrote:

Here is a table that I just recreated for this little test of the list
box fill procedu
F E Wheaton Main St Wheaton
F E Wheaton Main St Yorkville
Fox Home Center Broadway Alsip
ABC Supply Co Belmont Chicago
Bradco Supply Rathbone Montgomery
Bradco Supply Lake St Aurora
Gazebo Junction Rte 35 St. Charles
Deckman Lily Street Elburn
Deck Yard April St Big Rock
Allied Bldrs Leisure Ln Oswego
Evanston Lbr Charles Ln Evanston
Ericksons Pulaski Chicago

Here are the results of clicking cmd_A:
Alsip
ABC Supply Co Belmont Chicago
Aurora
April St Big Rock
Allied Bldrs Leisure Ln Oswego

It looks to me like the code behind cmd_A is looking at the data like
r1c1, r1c2, r1c3, r2c1, r2c2, r2c3, r3c1, r3c2, r3c3 etc and anythime
the first letter in the cell is an A, it is starting a new entry in the
list box.

So perhaps the code for cmd_A needs to be modified to force the search
to work only on column 1.

Am I in the ballpark on this one?

I see the answer to my problem!! on the printout of the code you gave
me. I used A1:C333 for MyDataRange where I think I was supposed to use
A1:A333 - correct?

You got me thinking in code speak!! hooray

Will fix this then tackle the next problem in a new thread as you
suggested. Please let me know if this looks like it is my problem and
if I fixed it myself - I need the confidence ;- ) to tackle the rest of
this challenge


Ron Coderre wrote:

Since you're rapidly approaching the line between "Help me with this
question" and "Help me build a project", let's decide to work this,
issue-by-issue, in separate threads. There's a general tendency in the
newsgroups to let the primary responder continue with the thread. By posting
each request category separately, you'll get a larger pool of talent working
with you simultaneously.

Regarding your listbox issue, can you post some sample data (including the
problem items)? Alter any sensitive data, of course, but keep the structure
intact.

***********
Regards,
Ron

XL2002, WinXP


"Joanne" wrote:

Ron
When I paste my table data into your app, I get the same errors I do in
my app.
I see though that your data runs sweet in your app. I tried to put your
data into my app but couldn't get it to run from sheet2 because I don't
have enough excel knowledge to set it up.

What should I look at in the table. I cut and pasted it - am thinking I
should maybe re-create the table, as I was going to make additional
columns of info for each customer anyway so I would be doing quite a bit
of work to get the data where I want it?

What do you think?

Also, can we talk about how I will capture the choice the user makes so
that I can send it to a function that will read the data and eliminate
the columns and the sheets that are not needed for this particular
customer? There are 62 sheets on the master - only maybe half a dozen
will be relevant to a particular customer - I want the relevant columns
to be listed with the CustInfo record for each customer so that when I
capture the choice, I can read the record to see what sheets I will need
to present to the user and code the rest of the sheets to be deleted
from this instance of the 'copyOfMaster' workbook. Likewise, on the
sheets that I show the user, I need to dump maybe 5 or 6 columns, again
the info will be on the record in the table. After the sheet is built
the way the user needs it, it will be used to inform the customer and/or
be printed. Then the workbook will be deleted and the app shut down
until user needs to look up another customer's info.
I think this will work extremely well for my users, but the coding is
going to be a bit of a challenge for me, but I like a good challenge and
you mvps are always so willing to help us newbies along.
Again, I am learning a ton from you that will stay with me for future
projects, and I have a great appreciation for that.

Ron Coderre wrote:

http://www.savefile.com/files/864195