VBA programming

Originally Posted by kush28

Hey Excel Experts

am very new to VBA prgramming in excel.

I need to write a VBA (i already know how) to convert the data from one excel workbook into another excel workbook.

What i want to know is that how to implement my VBA so that i have a button on the menu or tool bar. Each time i click that button it should load my userform and when i click on the button on the userform or that button itself(Which is on the toolbar or menubar) it should convert my excel sheet into the other excel sheet.

Can anyone please help .

Kush

RightClick anywhere on any tool bar, from the quick menu choose "customise", from the "customise" window that appears choose "command" tab, from the left side "categories" pane choose "macros", from rightside pane pick and drag custom button ( yellow smilee ) to any tool bar. Don't yet close the "customise" window and right click the button on the toolbar you just have placed. from quick menu choose "assign macro" and then assign the sub you have written. You can edit the appearance of button ( yellow smilee to anything ) or edit the properties by right clicking on the button anytime but first make sure that you have the "Customise " window open ( rightclick anywhere on a tool bar>choose customise ). If you want to remove the button press ALT and drag the button out from the tool bar on to the sheet.

A V Veerkar