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


--
kush28
------------------------------------------------------------------------
kush28's Profile: http://www.excelforum.com/member.php...o&userid=31036
View this thread: http://www.excelforum.com/showthread...hreadid=510449

kush28 Wrote:
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 barchoose 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


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=510449