| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba code to get an duse the value from a particular cell
Using xl2003, I have the following Worksheet Selection Change code:
If Target.Column = 5 Then Target.Columns.ColumnWidth = 27.11 ActiveWindow.Zoom = 85 Else Columns(5).ColumnWidth = 3.78 'ActiveWindow.Zoom = 75 End If I would like to be able to change the values zoom 85 and 75 to correspond to the values in 2 cells, for eample, Notes!B5 and Notes! B6, so the zoom factors can be set as needed. How can this be done? As always, Thanks, Tonso |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| VBA Code when a cell is selected | Excel Discussion (Misc queries) | |||
| add code to a cell via macro | Excel Discussion (Misc queries) | |||
Threaded Mode
