| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to fill in formulas in Cells
I have a userform that has a selection method... I would like to fill range of cells with a different formula depending on which cmd butto is pressed in the form. The Formula is a lookup and it is the same it just refers to differen sheets based on the user input... Thank You -- NetWave12 ----------------------------------------------------------------------- NetWave128's Profile: http://www.excelforum.com/member.php...nfo&userid=229 View this thread: http://www.excelforum.com/showthread.php?threadid=27408 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use VBA to fill in formulas in Cells
Selection.Formula = "=VLOOKUP(A1, $B$1:$C$1000, 2, FALSE)"
-- Rob van Gelder - http://www.vangelder.co.nz/excel "NetWave128" wrote in message ... I have a userform that has a selection method... I would like to fill a range of cells with a different formula depending on which cmd button is pressed in the form. The Formula is a lookup and it is the same it just refers to different sheets based on the user input... Thank You- -- NetWave128 ------------------------------------------------------------------------ NetWave128's Profile: http://www.excelforum.com/member.php...fo&userid=2297 View this thread: http://www.excelforum.com/showthread...hreadid=274089 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help Fill formulas, highlight cells to specified destination | Excel Discussion (Misc queries) | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| create a fill in template to tab to fill in cells | Excel Discussion (Misc queries) | |||
![NetWave128[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
