LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Transfering Data from ListBox to Worksheet

I have created a UserForm with a ListBox. If the user clicks on the macro
button Add to List the ListBox is opened with all of the options, and now
you can simply click on the item(s) you want to add to the worksheet sheet in
column B, starting at B8. I have it all set up to the point of transferring
the data (or item(s) selected) to the worksheet. i.e The ListBox of "item
options" comes up perfectly, I can select (highlight) the items I want to add
to the list on the worksheet but I dont know how to transfer the selected
(highlighted) items to the worksheet in the next open cell, starting with B8
by clicking on the OK command button.

Any help with the code needed for the OK button to transfer the data would
be greatly appreciated.

P.S. Thanks to Dick Kusleika for the previous suggestions, but neither
solved my problem.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfering of data from 1 worksheet to another nandosuperstar Excel Discussion (Misc queries) 2 October 31st 09 12:33 AM
Transfering data from worksheet to another Tasha Excel Discussion (Misc queries) 0 May 15th 06 03:20 PM
Transfering a row of data to a template word or worksheet Marc Williams Excel Discussion (Misc queries) 1 October 27th 05 12:33 AM
Transfering data from 1 worksheet to another Larry L Excel Discussion (Misc queries) 1 August 29th 05 01:30 PM
Transfering data from one worksheet to another Worksheet sryan Excel Programming 0 January 21st 04 12:41 PM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"