If I understand you
x = row number
y = column number
Than use: Cells(x,y)
instead of Range("A1")
make sure x & y are Dim as Long.
general statement include workbook, sheet, and range designater's
WorkBooks("MyBook").Sheets("MySheet").Cells(x,y) = "My Text"
--
steveB
Remove "AYN" from email to respond
"robhargreaves"
wrote in message
news:robhargreaves.1smlib_1122127507.0083@excelfor um-nospam.com...
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