Hi I am having trouble with my userform. I have 5 controls on the
form.

a calendar (calendar1)
2 combos (cbosite & cbometerno)
1 textbox (txtreading)
1 command button (cmdaddrecord)

The user selects a value in the calendar and this is added to the first
available row in the sheet.

cbosite has a selection of all the sheet names in the workbook. The
selection here decides which sheet the calendars input and the
txtreading is printed to.

up to now I have this part working. I choose a date, select a sheet
name from cbosite and click cmdaddrecord. This activates the relevant
sheet and enters the date in the first blank row in column a as the
code asks.

The part I dont know how to do is to take the row number from where
calendar 1 has just entered and put it on one side to use as the row
number to enter txtreading.

To find the column for txtreading I need to some how cross reference
the choice in cbometerno which will be found anywhere between B1:K1 and
take the column letter.

Once I have this I know that txtreading should be entered in row x and
column y.

I have tried to explain that as well as I can but I have attached a
copy of the sheet to this post if you want to have a look.

Thanks for your time having a look.

Rob


+-------------------------------------------------------------------+
|Filename: excelproject.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3619 |
+-------------------------------------------------------------------+

--
robhargreaves
------------------------------------------------------------------------
robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519
View this thread: http://www.excelforum.com/showthread...hreadid=389584