[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

VB command button help

Posted on 2012-08-23
6
Medium Priority
?
662 Views
Last Modified: 2012-08-25
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
0
Comment
Question by:Kiwi-123
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:Norie
ID: 38327589
You have buttons on the form that enter the current date in textbox2 and textbox2 doesn't appear wide enough to display a date.

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?
0
 

Author Comment

by:Kiwi-123
ID: 38327640
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.
0
 
LVL 35

Expert Comment

by:Norie
ID: 38327740
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?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Kiwi-123
ID: 38328187
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.
0
 
LVL 35

Accepted Solution

by:
Norie earned 2000 total points
ID: 38329353
See the attached.

I think I've covered everything.

By the way, I changed some of the names of the controls, having Textbox1, Textbox2 etc is just confusing.

I would suggest you do something similar yourself and give controls meaningful names.
Help-24-08-2012-V2.xls
0
 

Author Comment

by:Kiwi-123
ID: 38331361
Thanks for your help
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question