we want to search for an empty column and add items to that column using a vba form

by

It isn’t very clear what you are wanting, but I think this might point you in the right direction:

Sub foo()
Dim LastRow As Long
Dim LastCol As Long
LastCol = Worksheets("ComboBoxList").Cells(1, Worksheets("ComboBoxList").Columns.Count).End(xlToLeft).Column 
'find the last column with data on row 1 (add 1 to this number to find the next empty column)
LastRow = Worksheets("ComboBoxList").Cells(Worksheets("ComboBoxList").Rows.Count, LastCol).End(xlUp).Row 
'find the last row with data on the last column
Worksheets("ComboBoxList").Cells(LastRow + 1, LastCol).Value = Me.response.Value 
'add the value of Response to the next empty row in the last column (empty row is lastrow with data +1)
End Sub

More Related Contents:

  1. VBA – Search and replace with increment number
  2. Is there any event that fires when keys are pressed when editing a cell?
  3. Convert an entire range to uppercase without looping through all the cells
  4. Does the VBA “And” operator evaluate the second argument when the first is false?
  5. Split cell values into multiple rows and keep other data
  6. Save each sheet in a workbook to separate CSV files
  7. Difference between ‘on error goto 0’ and ‘on error goto -1’ — VBA
  8. Is VBA an OOP language, and does it support polymorphism?
  9. Export each sheet to a separate csv file
  10. What are .NumberFormat Options In Excel VBA?
  11. Excel: How to check if a cell is empty with VBA? [duplicate]
  12. Detect if range is empty
  13. Checking if a worksheet-based checkbox is checked
  14. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  15. Extract Data from Word Document to an Excel SpreadSheet
  16. Excel macro -Split comma separated entries to new rows [duplicate]
  17. VBA equivalent to Excel’s mod function
  18. Get text from clipboard using GetText – avoid error on empty clipboard
  19. Pointers needed for speeding up nested loop macro in VBA
  20. Display milliseconds in Excel
  21. VBA editor auto-deletes spaces at the ends of lines
  22. ‘1004’: “The sort reference is not valid.”
  23. Select entire column in table using Excel VBA
  24. Application.Quit command not closing the entire Excel Application
  25. Reducing WithEvent declarations and subs with VBA and ActiveX
  26. Trying to open the workbook in separate instance
  27. Function Overloading and UDF in Excel VBA
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment