Hi Tom,
Thanks for the help. I've a Query for you.
While executing it.
Combo Box is working. When i select a Date from Combo Box and When I
hit "OK"
"Run Time Error 1004" is displayed with a msg
*"Unable to get the Vlook up properties of the work sheet function
class" *
On Fri, Dec 12, 2008 at 1:28 AM, Tom Jeffries <tjeff...@gmail.com> wrote:
> Take a look at the attached workbook. I think it does what you want. Click
> the "RUN" button. From the form displayed select something from the
> comboBox and click the "OK" button. The three text boxes will be populated
> with data corresponding to your selection. If you have any questions let me
> know.
> Tom
>
> On Thu, Dec 11, 2008 at 8:26 AM, Karthick.A.R <milkywaykar...@gmail.com>wrote:
>
>>
>> Hi
>>
>> 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
>>
>> And when A3 is selected in combo box then
>>
>> simultaneous result.....
>>
>> Can anyone help me in coding.
>>
>>
>>
>
> >
>
--
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
-~----------~----~----~----~------~----~------~--~---
