Modifying John Walkenbach's Data Entry form

[Edwin]

I recently purchased the form and source from j-walk.com. While it's
great as is I just can't help mucking around with it and am looking to
modify the code so that I can use combo boxes and spin buttons.

There is a comment 'Is a Name defined with an array of choices? but
I'm not sure how to define the "array of choices".

I'm thinking that maybe if I set up an array to indicate whether an
entry field is a textboxe, spin button, combo, etc. that might work.

I'd greatly appreciate it if anybody or bodies could point me in the
right direction on doing this. And what other issues I should
consider.

TIA
Ed

 

[Tom Ogilvy]

Worksheets("sheet1").Range("A1:A100").Name = "List1"

creates a Name that refers to the range A1:A100 on Sheet1. This range would
hold the array of choices I suspect.

this could possibly be used as the source to your combobox.

 

[Edwin Steinberg]

Tom:
Thanks.
After receiving some other advice about the dangers of fooling around
with code that works (John's form) and that I don't really understand
yet, I'm taking the route of just doing my own form.
Ed

 

[Jon Peltier]

Ed -

As long as you don't damage the original file, you should look into
John's code. Make small changes and closely watch how they affect its
behavior. You will learn a lot.

- Jon