View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sami82[_6_] Sami82[_6_] is offline
external usenet poster
 
Posts: 1
Default Form Input, with (listbox) review then copy to worksheet


Hi All,
Hope you can help me here and that I'm not trying to do th
impossible.

I have a major module that I'm working on where the user inputs dat
into the form this data includes:
product
state
start date
end date
deal rate
total amount

I have 2 forms - one where the data is entered and the other where i
is reviewed(i was thinking of a listbox for the second)

The user puts in one product and the form transfers the data to th
different cells in the spreadsheet, and then the form is made blank an
the user can enter another product.

What I want is a middle / review section where the data is transfere
to a listbox so the user can double check the data. If the user woul
like to make changes they can click the line and will be returned t
the original form and the variables to that product line will be show
and can be edited.

When the review data as ok, teh user presses a button and then the dat
is transfered to the spreadsheet line by line.

I hope this makes sense and someone can help me as I am really stuc
and I am trying to get this finished asap.

THANK YOU AL

--
Sami8
-----------------------------------------------------------------------
Sami82's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=47199