addnew.offset0

can someone help me to loop this ? Dim wks As Worksheet Dim addnew As Range Dim addup(15) As Double Set wks = Sheet9 Set addnew = wks.Range("AG3").Offset(0, 0) If ecYes.Value = True Then addnew.Offset(0, 1).Value = ecYes.Caption ElseIf ecNo.Value = True...

can someone help me ?? what code who runs first to my userform_initialize.. Private Sub adddata_Click() Dim wks As Worksheet Dim addnew As Range Dim addup(15) As Double Set wks = Sheet9 Set addnew = wks.Range("AG3").Offset(0, 0) If ecYes.Value = True Then...

Hi. I have the below code to add data from a userform to a worksheet. Within the userform i also have a listbox which displays the data. Now what i am trying to do is for when a row of data is selected within the listbox, the text box input fields populate matching the data, so when i press...

Hi. I am having trouble showing source data in a listbox. I use the below code to enter data from the userform to a worksheet, then the last two lines of code displays all data within a listbox. And this works ok. But on first open of the userform i want the listbox to show the data already...