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!

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

Recent content by jiemei1

  1. jiemei1

    VBA and MS VB 6.3

    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
  2. jiemei1

    command button

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

    command button

    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
  4. jiemei1

    command button on worksheet(not user form)

    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
  5. jiemei1

    a small project

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

    a small project

    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...
  7. jiemei1

    a small project

    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,
  8. jiemei1

    a small project

    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...
  9. jiemei1

    a small project

    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...
  10. jiemei1

    combo box input range

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

Part and Inventory Search

Back
Top