Userform - 2 calculations needed.

[Fanciesmom]

First off I want to thank everyone here for all the wonderful information. This forum is fantastic.

The help I got getting my userform to report to the spreadsheet was invaluable. But now I have two more issues to resolve in order to get this part of the project done.

1: On the userform there is a textbox for "Resrv#". On the spreadsheet (availability) there is a formual that concatenates the row number and the date to create a reservation number. This is not going to work so I need a way to use the date and create a unique reservation number that can be used manually and on the worksheets. I am not sure how to do that and have it display in the textbox.

2: My idea is to have the worksheet "reservations" gather the data from the userform and then have that information be copied to the "availability" worksheet to provide a list of available sites on the "availabilty" and the "DATASHEET" worksheets (which needs to be updated as the sites are reserved and sorted by arrival date (and departure) so we know at any time what sites are available and for how long) and should update the range (Asite) on the "availabilitiy" worksheet and the range (Avail) "DATASHEET". That list is what the combobox CBSite pulls up so that the person making the reservation gets a list of only the sites that are available. Am I asking too much here? I know we have enough trouble just getting the people behind the desk to do this with pencil and paper with any reliability.

#1 is the most important at this moment.

Thanks in advance - you guys rock!

Here is the code so far:

Please Login or Register  to view this content.

[Fanciesmom]

I am looking at this post from yesterday and thinking I was not really clear about what I was trying to do (trying to work while taking meds for back spasms).

The immediate priority right now is to get the textbox (TBRsrvNum) to display a unique reservation number perhaps using the number value of the date and a number that can be random or consecutive. I currently have a formula on the worksheet creating the number using the date number and the row number but I HAVE to have a number on the userform BEFORE it's written to the file.

The person at the front desk needs to have the number for the paper copy of the reservation form (they will be filling out the information on the userform from a handwritten form - but they have to be able to put a reservation number on the form. (There will be no print function for this at the front desk).

thanks again