User Form Help Please

[mercmannick]

Hi

i would like to create a userform with a textbox to enter a product code , a command button to run VBA and a big text box to show output of VBA from Textbox 1 which i will connect to DB and pull back information relevant to that product code , is this possible i can create the userform no problem and already have code to pull back from DB into Excel , can anyone give me a idea how to do this if its atall possible

Thanks

Nick

 

[mercmannick]

Hi Norie ,

would be interested to see this in access , use excel as schedules in gannt chart format as you know from helping me set sheet up, to see the info from access the user dbl clicks on cell and that then pulls info from access to userform , are you saying i could do all this in access including my gannt charts , i already store all my info in access and pull back with querys to excel , can you tell me best way to start begin as such

Many Thanks

Nick

 

[mercmannick]

Can anyone give me a idea on how to begin and how to acheive what norie was suggesting

MANY THANKS

Nick