Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default displaying info on a form

using a large list box on one form should do the job,
each line would have to be a seperate row and column break too

listbox1.ColumnCount = 3
for coun = 0 to (amount or rows to add)
listbox1.additem
listbox1.List(coun, 0) = columnone data
listbox1.List(coun, 1) = columntwo data
listbox1.List(coun, 2) = columnthree data
Next

you can add as many columns or rows as needed.

=)
Ben

"JT" wrote:

The user enters info into 5 text boxes and pushes a button
to build a journal voucher.

There is another button they push if they need to build a
multi-line journal voucher.

Displaying the JV information on the form is not an issue
with a JV that is 1 - 6 lines long. The information is
displayed so they can review it and make changes before
hitting the "submit" button

I'm looking for suggestions on how to display the
information if the JV is 7 or more lines because it won't
fit on the form. The issue is I never know how may lines
the JV may contain.

I can add multi pages but again I don't know how many. Is
there a way to display information on a form and build it
dynamicly instead of having a set number of pages?

I have also thought about combo boxes and list boxes.

Any examples or suggestions on how to accomplish this
would be appreciated. Thanks for the help.

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
matching key fields between two workbooks and displaying info when tukky142 Excel Worksheet Functions 2 April 10th 07 08:40 PM
Displaying info in a new tab in excel Khamul Excel Worksheet Functions 4 August 16th 05 06:18 AM
Extracting info from word and displaying in an excel spreadsheet Drew Excel Discussion (Misc queries) 0 March 7th 05 03:49 AM
Displaying File in Use By Info with vba s0mistr Excel Programming 1 May 18th 04 11:53 AM
Displaying info John Excel Programming 0 August 25th 03 01:55 PM


All times are GMT +1. The time now is 11:11 PM.

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"