Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 2nd 03, 10:52 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2003
Posts: 1
Default Selecting multiple rows from listbox for reporting

Hi -
I want to offer the ability for a user to scroll through records
displayed in a listbox and then display the single record on a user
form report. Then I want to use Previous / Next buttons to scroll
through the records and display the chart. Sample code to help with
this would be much appreciated. If the sample code allows for multiple
selections from the list box, with scrolling through only the selected
records / rows, that would make my weekend!

I wanted to look at the code in the very nice Village Software samples
in Excel 2000, but they are password protected (hint?).

Thanks for a great forum!
Brett Strouss
bstrouss at sensoryarts.com
'www.pockethearo.com' (http://www.pockethearo.com)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


  #2   Report Post  
Old November 2nd 03, 02:34 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Selecting multiple rows from listbox for reporting

Set the multiselect property of the listbox to true and the user can select
multiple records. It won't collapse the listbox to include only those
selected records unless you add a button that includes code to reload the
listbox with only the selected records.

See help on the selected property of the listbox for sample code.

Loading a listbox is pretty basic stuff - you either set the rowsource to
the range, or you use additem to add the rows or you can set the list or
column properties to an array.

Here are some references if you are looking for basic help on how to use a
userform:

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.



http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp

--
Regards,
Tom Ogilvy

Brett9 wrote in message
...
Hi -
I want to offer the ability for a user to scroll through records
displayed in a listbox and then display the single record on a user
form report. Then I want to use Previous / Next buttons to scroll
through the records and display the chart. Sample code to help with
this would be much appreciated. If the sample code allows for multiple
selections from the list box, with scrolling through only the selected
records / rows, that would make my weekend!

I wanted to look at the code in the very nice Village Software samples
in Excel 2000, but they are password protected (hint?).

Thanks for a great forum!
Brett Strouss
bstrouss at sensoryarts.com
'www.pockethearo.com' (http://www.pockethearo.com)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



  #3   Report Post  
Old November 5th 03, 10:25 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2003
Posts: 1
Default Selecting multiple rows from listbox for reporting


Thanks for the solid reference info. I never got it to work the way I
expected. I ended up leaving out the multi-selection list box or combo
box and just manually scrolled through the list, displaying the
selected record identifier in a Text Box. That part works OK for this
iteration. Thanks for the help!
Brett


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

  #4   Report Post  
Old November 5th 03, 11:07 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2003
Posts: 1
Default Selecting multiple rows from listbox for reporting


Thanks for the solid reference info. I never got it to work the way I
expected. I ended up leaving out the multi-selection list box or combo
box and just manually scrolled through the list, displaying the
selected record identifier in a Text Box. That part works OK for this
iteration. Thanks for the help!
Brett


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/



Reply
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
Selecting row data, filter out column nulls and reporting results? thayes Excel Discussion (Misc queries) 5 March 16th 09 08:54 AM
Selecting multiple rows Soheyl Excel Discussion (Misc queries) 1 June 12th 07 01:41 AM
multiple columns / rows to be referenced through a listbox Hru48 Excel Discussion (Misc queries) 0 July 4th 05 04:12 PM
selecting multiple rows Stuart[_8_] Excel Programming 2 October 4th 03 03:24 AM
selecting multiple rows within a Macro Tom Ogilvy Excel Programming 0 August 30th 03 01:08 AM


All times are GMT +1. The time now is 02:15 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017