Thread: Data from user form to certain cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
parteegolfer parteegolfer is offline
external usenet poster
  
Posts: 1
Default Data from user form to certain cell

I am trying to take a few items selected from a user form and inser
them into certain cells in a given worksheet. Below is the code,
think I am close however it does not work. Any suggestions?

Private Sub CommandButton1_Click()

Sheet1.Cells("F1").Value = ComboBox2.Text <<This is my issue
Sheet1.Cells("F2").Value = ComboBox2.Text <<This is my issue

MsgBox "One record written to Sheet1"

response = MsgBox("Do you want to enter another record?", _
vbYesNo)

If response = vbNo Then
Unload Me
End If

End Su

--
parteegolfe
-----------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...fo&userid=3195
View this thread: http://www.excelforum.com/showthread.php?threadid=52529

Reply With QuoteReply With Quote