Kiwi-123
asked on
VB command button help
Please can you help, I was hoping to integrate, TextBox19 to Textbox 2
& Textbox 20 to Textbox 4
(Both 19 & 20 have background as yellow)
Basically Textbox 19 contains the date "dd/mm/yyyy" I was hoping that Textbox 2 could be a free text field that you could enter the time "1230", the userform would then post this date and time in offset 7 & 21 on the other.
The problem for me is linking the two and also adding the ":" inbetween the hh:MM
Many thanks for your help!
Help-23-08-2012.xls
& Textbox 20 to Textbox 4
(Both 19 & 20 have background as yellow)
Basically Textbox 19 contains the date "dd/mm/yyyy" I was hoping that Textbox 2 could be a free text field that you could enter the time "1230", the userform would then post this date and time in offset 7 & 21 on the other.
The problem for me is linking the two and also adding the ":" inbetween the hh:MM
Many thanks for your help!
Help-23-08-2012.xls
ASKER
Hi Imnorie,
Yes it is columns I and W
Yes sorry, Date in Textbox 2 then time in Texbox 19
Then
Date in Textbox 4 and time in Textbox 20
If possible I'd also like to return the values if they already appear on the line. If not the textboxes will be blank on a brand new line.
Yes it is columns I and W
Yes sorry, Date in Textbox 2 then time in Texbox 19
Then
Date in Textbox 4 and time in Textbox 20
If possible I'd also like to return the values if they already appear on the line. If not the textboxes will be blank on a brand new line.
I'm a bit lost.
Which textboxes are to go in which columns?
Is it TextBox2/19 into column I and Textbox4/20 into column W?
Also, what do you mean by return the values if they appear on the line?
Return the values when?
Which textboxes are to go in which columns?
Is it TextBox2/19 into column I and Textbox4/20 into column W?
Also, what do you mean by return the values if they appear on the line?
Return the values when?
ASKER
Is it TextBox2/19 into column I and Textbox4/20 into column W?
Yes that is correct
Also, what do you mean by return the values if they appear on the line?
If the line already has a date/time, then this will appear on the userform when it opens. If not, the userform textbox2/19 & 4/20 will appear blank on a line with no values in column W & I
Return the values when?
Into the textbox, your see an example of this on the other textboxes within the userform.
Yes that is correct
Also, what do you mean by return the values if they appear on the line?
If the line already has a date/time, then this will appear on the userform when it opens. If not, the userform textbox2/19 & 4/20 will appear blank on a line with no values in column W & I
Return the values when?
Into the textbox, your see an example of this on the other textboxes within the userform.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help
Is it the other way round? Time in Textbox19 and date in Textbox2.
Also, which columns on the worksheet is the date/time to go in?
Is it column I and W?