Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    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?

  2. #2
    Bronze Lounger
    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.

    <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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts