Thread: [Solved] how do I handle user input not in combobox
View Single Post
 
Old 03-31-2022, 01:00 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Hope I've Correctly understood ...

If you arw using a Form with controls on it to write data to a sheet ... try specifying the use of a form:

Code:
.Cells(sheetRow, 1).Value =Me.TextBoxName.Text
         .Cells(sheetRow, 2).Value = Me.TextBoxAddress.Text
        .Cells(sheetRow, 3).Value = Me.TextBoxCity.Text
Reply With Quote