The code below adds a value, one time, to the "fbaship" sheet. I'm adding a text box next to the command button so I can add the same value x number of times. I may want to add the same sku one time or 20 times. Obviously, I can repeat pressing the command button multiple times but I'd prefer to type in a number and be done! Requesting help with how to do that.
Private Sub add_fba_ship_temp_cmbbut_Click() Dim fbaship As Worksheet Dim fbasku As Range Set fbaship = ThisWorkbook.Worksheets("FBA Ship Template 2017") Set fbasku = fbaship.Range("D:D") fbaship.Range("D" & Rows.Count).End(xlUp).Offset(1).Value = search_merch_sku_txtbox.Value End Sub
Bookmarks