I have a form in my excel worksheet.
How to navigate from one cell to another.
For example, I have a cell B2 and a cell D9.
When I click on "TAB", I would like to move directly from B2 to D9

Thanks for your hel

--
ecohen
-----------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...fo&userid=1298
View this thread: http://www.excelforum.com/showthread.php?threadid=48795

Hi ecohen1

If you unlock B2 and D9 in the cell properties and protect the sheet the tab key do what you want.



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" wrote in message
...

I have a form in my excel worksheet.
How to navigate from one cell to another.
For example, I have a cell B2 and a cell D9.
When I click on "TAB", I would like to move directly from B2 to D9

Thanks for your help


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952

Thanks Ron.
But is this a way to do it programmatically or with a formula?


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952

Which Excel version do you use ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" wrote in message
...

Thanks Ron.
But is this a way to do it programmatically or with a formula?


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952

I use Excel 2003


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952

Do you know that you can uncheck "Select locked cells" when you protect your sheet.
This way the user can't select locked cells.

If you only have a few cells to fill in and wat to use a macro then try this

Sub test_1()
Dim myRange As Range
Dim myCell As Range
Dim myAns As Variant

Set myRange = Range("I3,K7,M11")

For Each myCell In myRange.Cells
myAns = InputBox _
(prompt:="Please enter something for cell: " & myCell.Address, _
Title:="Get Data")
If myAns < "" Then
myCell.Value = myAns
End If
Next myCell
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" wrote in message
...

I use Excel 2003


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952

Hello,
Try Unlocking the cells and then protect the sheet.

Format cell/protection click off locked then go to tools/protection/Protect
Sheet

Lime

"ecohen1" wrote:


I have a form in my excel worksheet.
How to navigate from one cell to another.
For example, I have a cell B2 and a cell D9.
When I click on "TAB", I would like to move directly from B2 to D9

Thanks for your help


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=487952