Consulting

Results 1 to 3 of 3

Thread: User Form how add additional boxes and dropdown boxes with a command Button?

  1. #1
    VBAX Newbie
    Joined
    Aug 2018
    Posts
    1
    Location

    User Form how add additional boxes and dropdown boxes with a command Button?

    Hello,

    I have created several user forms, and there is always a new challenging requirement that will slow me down a lot. I need your help!
    The user form has a drop box for "Job Title", to the right a box for "Rate". I use a Vlookup to populate the rate base on the job title selection.

    I need a command button that will duplicate the dropbox, box and vlookup formula, everytime the button is pressed.

    Greatly appreciate your help,
    S

  2. #2
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    606
    Location
    .
    What do you mean :
    a command button that will duplicate the dropbox, box and vlookup formula

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    Whatever reason can you have to duplicate the dropbox, you will end up with dozens of the things and ut will become unusable.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Tags for this Thread

Posting Permissions

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