hobbiton73
02-02-2013, 09:57 AM
Hi, I wonder whether someone may be able to help me please.
I'm using this worksheet https://www.box.com/s/q6ulkp0zp2ycxo0utgfa to record staff resource.
As you can see in column B, there is a value of "Enter your name", which instructs the user where to start entering their information. Then, when the user enters their details in this row, the next row is popluated with the pre-defined text.
and this is the piece of code in my script which creates this value:
With Target
Select Case True
Case .Column = 2
If .Value2 <> "Enter your name" And .Offset(, -1) = "" Then
Set FirstBlankCell = Range("B" & Rows.Count).End(xlUp).Offset(1, 0)
FirstBlankCell.Value = "Enter your name"
End If
Case Else
End Select
End With
Unfortunately I have some users who are unable to follow such a simple instruction and start to enter their details into any row.
Could someone perhaps tell me please, how I may go about adapting this so that any rows in column B after this text value are locked, thus forcing the user to enter the details where I would like them to start.
Many thanks and kind regards
Chris
I'm using this worksheet https://www.box.com/s/q6ulkp0zp2ycxo0utgfa to record staff resource.
As you can see in column B, there is a value of "Enter your name", which instructs the user where to start entering their information. Then, when the user enters their details in this row, the next row is popluated with the pre-defined text.
and this is the piece of code in my script which creates this value:
With Target
Select Case True
Case .Column = 2
If .Value2 <> "Enter your name" And .Offset(, -1) = "" Then
Set FirstBlankCell = Range("B" & Rows.Count).End(xlUp).Offset(1, 0)
FirstBlankCell.Value = "Enter your name"
End If
Case Else
End Select
End With
Unfortunately I have some users who are unable to follow such a simple instruction and start to enter their details into any row.
Could someone perhaps tell me please, how I may go about adapting this so that any rows in column B after this text value are locked, thus forcing the user to enter the details where I would like them to start.
Many thanks and kind regards
Chris