Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linking vb program to excel

Status
Not open for further replies.

sf123

Programmer
Oct 9, 2002
30
US
I am working on an excel/vb project. I have data taken from sql displayed in a worksheet in excel. I created an addition menu to my excel toolbar and want to add code to the menu items in that menu that will pull up a form that was written in vb. In that form I want the user to be able to select different options of what they would like to view from the data in the spreadsheet so they don’t have to look at 5000 lines of data. When user presses submit I would like to create a new worksheet from the original one based on user specifications. My problem is calling the vb form from excel and creating something in excel from the form. information that I stored in variables. Can someone direct me to information (helpful links) that would be useful for me to proceed with this project. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top