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!

Search results for query: *

  1. bagnall

    Pasting data retrieved from a list box

    Mike, Thanks again, I thought I had tried every possible syntax with List, ListBox and ListIndex. It has re-affirmed my faith in human nature to find an electric community of people generous enough to help even the terminally bewildered. Rgds Simon
  2. bagnall

    Pasting data retrieved from a list box

    Thank you for all your help. Using Code from Rmikesmith I now have a UserForm which does what I needed, my only problem is that the I get the value above the one that I pick, and I would like to always make the active cell to be in column A. Here is the code I am using. Sub ItemForm()...
  3. bagnall

    Pasting data retrieved from a list box

    Dear Mike, Thank you so much for the code, I wonder if I could prevail on your good nature even further. I would like to put a second command button that would insert, rather than paste the information, and additionally two of the seven columns (D & E ) contain formulae, but they are returned...
  4. bagnall

    Pasting data retrieved from a list box

    Help for an absolute beginner please. WorkBook A has a user form with a single selection ListBox with seven columns filled from a range in WorkBook B. I need the code to insert the selected cells into a row in Workbook A. starting at the active cell.

Part and Inventory Search

Back
Top