Hello,
I am seeking help to dispaly the value from sheet into text box. Here are the details.
When i select any item from combobox then the fax number should show in textbox2 for that perticular selected item i.e. Provider Fax No.
If possible i need day and time difference in frame 1 fields i.e. turnaround time frame.
Sample sheet is attached for your refference.
Hello hecgroups,
Change you ComboxBox event code to what is below. Delete the old code.
Private Sub ComboBox1_Click() ' ComboBox's first element starts at zero. First row of the worksheet starts at row 2. ' Fax number is in column "E". If ComboBox1.ListIndex > -1 Then TextBox2.Text = Cells(ComboBox1.ListIndex + 2, "E") End If End Sub
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith Ross it works.
I have another issue also Turnaround time
Textbox8 = Textbox3-Textbox5 (This is to find no. of days)
Textbox9 = Textbox4-Textbox6 (This is to find no. of days) But i need to find difference between AM to PM & PM to AM.
Let say i received approval at 04:00 PM on 04/07/2012 and i have replied on 05/07/2012 09:05 AM. I have try it but failed.
Can you fix this also please.
Thanks for your help.
It is working when data sheet is active otherwise it is not working any idea about this issue please.
Hello hecgroups,
Can you show me a before and after example of your previous post? I am not sure how the data should be formatted in the text boxes.
dd/mm/yyyy format but i have issue with PM-AM & AM-PM
I hope you unnderstand what i mean
Hello Leith
Please help out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks