User Form Question

[Guzzlr]

Hello All,
I'm having a little difficulty with learning about User Form's

My Code Thus Far:

 [COLOR=#339933]'While Loop Checks for Data Beginning In Line 17[/COLOR] 
RowCounter = 17
    While Cells(RowCounter, 2).Value <> ""
        RowCounter = RowCounter + 1
    Wend    
[COLOR=#339900]'Data Input Into Excel Sheet[/COLOR]
    Cells(RowCounter, 2).Value = Tbx_Date.Text
    Cells(RowCounter, 3).Value = Tbx_Time.Value

So, My User Form has two fields to fill in:
1. "Date Field"
2. "Time Field"

When I fill in the Date Field, the User Form enters the date in RANGE(B17), as it should, and continues with B18, B19 as new dates are entered. So the Date Field is working Correctly.

My "Time Field" is not working correctly. When I enter a number ie: 1.5, the code faults on:
Cells(RowCounter, 3).Value = Tbx_Time.Value

What I'm trying to accomplish, is the Date in B17 and the corresponding time in C18.

Thanks for the help
excel 2013

PS, at this time, I have no declarations, which is probably wrong...

 

[My Aswer Is This]

I never click on links.

This is a simple little thing your wanting
I do not need to see a file or image
We have two textboxes here:
You said there names were:
Tbx_Time
Tbx_Date


Do you mean there names are:

"Date"
"Time"

If so those are not good names to be used.

 

[My Aswer Is This]

If the textbox names are not correct just modify the script.

 

[MARK858]

@Guzzlr, did you see post number 9 by Fluff?

 

[Guzzlr]

The problem is that the textbox is called Tbx_Upper not Tbx_Time

I'm not seeing a Tbx Upper, just Tbx _Date and Tbx_Time
?
thanks

 

[Guzzlr]

Cells(Lastrow, 3).Value = Tbx_Time.Value

What exactly does this line of code mean? Especially the "3"

Thanks

 

[Fluff]

I'm not seeing a Tbx Upper, just Tbx _Date and Tbx_Time
?
thanks

In the file that you supplied, if you select the lower of the 2 textboxes & look at the properties window you'll see that the Name says Tbx_Upper

 

[My Aswer Is This]

If means the value from you textbox will be entered in the last row with data plus one row the 3 means column (3)

Cells(Lastrow, 3).Value = Tbx_Time.Value

What exactly does this line of code mean? Especially the "3"

Thanks

 

[Guzzlr]

In the file that you supplied, if you select the lower of the 2 textboxes & look at the properties window you'll see that the Name says Tbx_Upper

Oh...Now it Works, Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Guzzlr]

One more question..

How do i get the the top left corner of the user form to show on F2?
Thanks