Cell Tabulation

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

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" <ecohen1.1z0bey_1132845302.8224@excelforum-nospam.com> wrote in message
news:ecohen1.1z0bey_1132845302.8224@excelforum-nospam.com...
>
> 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?

Which Excel version do you use ?

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


"ecohen1" <ecohen1.1z0fky_1132850702.0577@excelforum-nospam.com> wrote in message
news:ecohen1.1z0fky_1132850702.0577@excelforum-nospam.com...
>
> 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

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" <ecohen1.1z0jqz_1132856102.6358@excelforum-nospam.com> wrote in message
news:ecohen1.1z0jqz_1132856102.6358@excelforum-nospam.com...
>
> 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
>
>