ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   displaying info on a form (https://www.excelbanter.com/excel-programming/322321-displaying-info-form.html)

JT[_2_]

displaying info on a form
 
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.

Ben

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.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com