Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel limit data entry range, control cursor movement to 2 cols
control cursor movement to 2 columns, left to right, jump to line 2. Able to
protect columns to right, but cursor jumps to column 3. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel limit data entry range, control cursor movement to 2 cols
You can limit the scroll area. In the VBE select the sheet you want to limit
and then in the properties set the scroll area to the two columns you want... -- HTH... Jim Thomlinson "Bob" wrote: control cursor movement to 2 columns, left to right, jump to line 2. Able to protect columns to right, but cursor jumps to column 3. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel limit data entry range, control cursor movement to 2 col
Found VBE: Tools - Macro - VBE
Screen goes to gray, only selection I see is "save", I don't see how to select a sheet, and don't see any menu drop down for properties. Read about VBE, but not used... "Jim Thomlinson" wrote: You can limit the scroll area. In the VBE select the sheet you want to limit and then in the properties set the scroll area to the two columns you want... -- HTH... Jim Thomlinson "Bob" wrote: control cursor movement to 2 columns, left to right, jump to line 2. Able to protect columns to right, but cursor jumps to column 3. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel limit data entry range, control cursor movement to 2 col
There are a couple of parts to the VBE that are important here. They are all
selected from the view menu Project Explorer - Gives you a data treee structure similar to windows explorer but it shows the workbooks and worksheets and any code modules or forms that yu have. It is here htat you cna select which sheet you want to modify by double clicking the sheet. Properties - This gives you a list of properties for the itme you select in the project explorer. This is where you will find a setting for the scroll area. Code Window - Not important for this task but it is where you would write code if that was you plan... By clicking on the itmes in the view tab you can make the different windows visible. -- HTH... Jim Thomlinson "Bob" wrote: Found VBE: Tools - Macro - VBE Screen goes to gray, only selection I see is "save", I don't see how to select a sheet, and don't see any menu drop down for properties. Read about VBE, but not used... "Jim Thomlinson" wrote: You can limit the scroll area. In the VBE select the sheet you want to limit and then in the properties set the scroll area to the two columns you want... -- HTH... Jim Thomlinson "Bob" wrote: control cursor movement to 2 columns, left to right, jump to line 2. Able to protect columns to right, but cursor jumps to column 3. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel limit data entry range, control cursor movement to 2 col
After I highlighted the range in excel sheet, it worked like a charm.
Thanks, CTRL-R, F4 "Jim Thomlinson" wrote: There are a couple of parts to the VBE that are important here. They are all selected from the view menu Project Explorer - Gives you a data treee structure similar to windows explorer but it shows the workbooks and worksheets and any code modules or forms that yu have. It is here htat you cna select which sheet you want to modify by double clicking the sheet. Properties - This gives you a list of properties for the itme you select in the project explorer. This is where you will find a setting for the scroll area. Code Window - Not important for this task but it is where you would write code if that was you plan... By clicking on the itmes in the view tab you can make the different windows visible. -- HTH... Jim Thomlinson "Bob" wrote: Found VBE: Tools - Macro - VBE Screen goes to gray, only selection I see is "save", I don't see how to select a sheet, and don't see any menu drop down for properties. Read about VBE, but not used... "Jim Thomlinson" wrote: You can limit the scroll area. In the VBE select the sheet you want to limit and then in the properties set the scroll area to the two columns you want... -- HTH... Jim Thomlinson "Bob" wrote: control cursor movement to 2 columns, left to right, jump to line 2. Able to protect columns to right, but cursor jumps to column 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
control speed of cursor box movement | Excel Discussion (Misc queries) | |||
how can I limit cursor movement within specified range in excel? | Excel Discussion (Misc queries) | |||
How can you limit the data entry range in Excel? | Excel Worksheet Functions | |||
Control Cursor movement with Tab | Excel Discussion (Misc queries) | |||
Cursor Movement vs. Range Reference | Excel Programming |