Results 1 to 2 of 2
Thread: Use a UserForm? (2000 / SR-1)
2004-03-31, 20:06 #1
- Join Date
- Sep 2002
- Chicago, Illinois, USA
- Thanked 0 Times in 0 Posts
Use a UserForm? (2000 / SR-1)
I am developing a worksheet (template?) that will contain 50-100 rows of information imported from an Access database. The worksheet will be sent to a non-Access user to make updates to the information (add/change/delete), and subsequently the worksheet will be returned for to update the Access database. Being a UserForm novice, I'd like to know if there would be any advantage to developing a one to facilitate and control worksheet updating. If bound controls are placed on the userform, how do you specify a range of values? Finally, would using Data|Form or the Template Wizard with Data Tracking add-in be a better route to go?
2004-03-31, 20:32 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: Use a UserForm? (2000 / SR-1)
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> JSS
Oh boy did you hit it right on the nail when you said: <font color=blue>"developing a one to facilitate and control worksheet updating"</font color=blue>
Yes I think controlling what the user does via a UserForm is a great way of doing so. Now I say that with a bit of reservations, because the development of an elegant UserForm is time consuming, but rewarding and the control needs to offset that time investment.
Since you say you are a<font color=blue> "UserForm novice"</font color=blue> I say Buddy take the plung and enjoy it. And to help you out check this From J-Walks web site and
Excel VBA UserForm Lessons which I did not check out, so you are on your own with this one.
If you do a Google using "UserForm"+Excel, you will get some neat hits.
Best of luck, and let us know how we can help.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>