Hi Karthick, Check this file and let me know your ideas.
regards
Officevbatrainer
________________________________
From: Karthick.A.R <milkywaykar...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Thursday, December 18, 2008 2:33:43 PM
Subject: $$Excel-Macros$$ Problem with date
Hi all
I've created a form with one combo box and three text box in Excel Vba
On load i wanna display column A2:A100 in Combo box from
"sheet1" (Excel file is "book1")
And when A2 is selected in combo box then
Textbox1.text should show "B2" &
Textbox2.text = c2
Textbox3.text = d2 act....
"Since column one is Date the simple coding used is not working"
Can any one help me to sort it out.
Attached excel contain the details.
Thanks in Advance
--
Karthick A Raju
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
Check.xls
Description: MS-Excel spreadsheet
