I need to know if my request is possible or look for another way - User Form


New Member
Mar 3, 2015
Is it possible have a command button that adds more boxes with the code below the existing ones? The user form has 3 rows, but it needs to have the ability to add more, since the project can have 40 jobs.

User Form to create a budget.,
It contains the following boxes like on a row, one next to each other with the labels
"Job Title", "Hours", "Hour Rate", "Total Amount"

Job Title is a combo box an the others are Text box

The user picks the job title from the combo box and the Rate field is populated using the following

Private Sub CommandButton1_Click()

Dim lookupm As Range
'Lookup values based on first control
Set lookupm = Range("BB:CC")
With Me
.URateV = Application.WorksheetFunction.Vlookup(Me.JobTV1, Worksheets("Job title PR ").Range("lookupm"), 2, 0)

End With
End Sub

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...