Recent content by jiemei1

Under my VB Editor, I have Microsoft Visual Basic Help. when I read a VBA book, They recommend install VBA help file. are they very different? Thanks, Jane

Thanks, I neet to click the Design Mode button first to view "Command" button(from Control Toolbox) code.

I have a command button on my worksheet not User form. I should be able to link the button to any Marco but can't do it on my new computer. Any one know why? I am using Excel 2003. Thanks

I am tryng to put a command button on my worksheet. once I click the button, I should be able to get: Private Sub CommandButton1_Click() End Sub the problem is that I am not getting the result I want. Any one know why? I am using Excel 2003. Thanks

Thank you very much! That is exactly what I need! Jane

Yes, I got it from the control toolbar. just go to "View" select "Toolbars" then activated "Control Toolbox". You can choose a lot of button from there - list box, combo box, toggle botton etc. Base on the book, I am suppose to set properties etc by right clik the bottom but I can't do it, why...

Then why all my ActiveX button is not working? For example, when I right click the Common button, I should be able to set properties, assign marcro, etc. any where I need to reset to make them work? Thanks,

the code below is intend to look into a Combo box for the year value then go into the correspondent worksheet. IT is in the process to install VBA on my computer so I can't test my code. Two things I am not sure base on the code I wrote: 1. I used Combo box for info input. combo box is link to...

I need to develope a program that use ActiveX control on the first workbook to gather year and two different product code, then return the price variance in a text box on the first workbook. there are several workbooks in one excel file. the first workbook contains all the ActivX control...

How can I use the input range but the combo box will only show unique value? Thanks