Search results for query: *

problem solved thanks sorry for irritating you

error in my first post. I want to have the text in cell A1, B1 & E1 copied into txtbxName.text, txtbxCity.text & txtbxState.text the row destination needs to be a variable so it can be stepped to the next one.

what i will be doing is pressing a "next" button after a form is filled and printed with customer info and onto the next reading from a spreadsheet and filling my form blanks

I have a spreadsheet with customer data (some columns...oops that would be A1...C1... of data I don't need.) Private Sub cmdSkip_Click() Dim vTime As Date vRow = (vRow + 1) txtbxDate.Text = Cells(vRow, 1) vTime = Cells(vRow, 2) txtbxTime.Text = vTime txtbxTransactionID.Text = Cells(vRow...

can't believe the problem I am having for a simple task I want to read cell A1 and copy that value into txtbxName.text then go to A3 and copy that value into txtbxState.text, I need the "A" to be a variable so I can hit the "next" button and go down my sheet. I know 4 different ways this can be...

Still ran into problems with the above code... so I Dim vTime As Date vTime = Range("B2").Value Me.txtbxTime = vTime and it worked but thanks for your help guys... I'm sure I will be back soon

cell B2 has a time (24hr) 8:23:28 in it. I want to copy this time into txtbxTime I tried: Me.txtbxTime.ControlSource = ("B" & 2) but the time 8:23:28 is looking like 0.34962962962963 How can I do this?