Thread: Data from user form to certain cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Edward Ulle Edward Ulle is offline
external usenet poster
  
Posts: 92
Default Data from user form to certain cell
I don't usually uses Cells. I use Offset. And I've discovered that Cells
will not take string. You would have to use an index or row column
number.


Worksheets("Sheets1").Cells(1,6) = ComboBox2.Text ' F1
Worksheets("Sheets1").Cells(2,6) = ComboBox2.Text ' F2

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote