Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row select
i have a workbook that has a Parameters page. Right now, all the information
shows no matter the selection on the Control page. I want to make it so depending on the variable selected on the Control page, the Parameters just shows items related to the selection. Control -- user picks A Parameters -- only display things related to A (which is a row of data) If anyone could offer any help. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
row select
You could use the worksheet's selection change event to change a cell used by a VLOOKUP formula to
extract the data related to Parameters. -- HTH, Bernie MS Excel MVP "Monique" wrote in message ... i have a workbook that has a Parameters page. Right now, all the information shows no matter the selection on the Control page. I want to make it so depending on the variable selected on the Control page, the Parameters just shows items related to the selection. Control -- user picks A Parameters -- only display things related to A (which is a row of data) If anyone could offer any help. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
row select
For display purposes, I only want to see that row on that page though. Is
that possible? "Bernie Deitrick" wrote: You could use the worksheet's selection change event to change a cell used by a VLOOKUP formula to extract the data related to Parameters. -- HTH, Bernie MS Excel MVP "Monique" wrote in message ... i have a workbook that has a Parameters page. Right now, all the information shows no matter the selection on the Control page. I want to make it so depending on the variable selected on the Control page, the Parameters just shows items related to the selection. Control -- user picks A Parameters -- only display things related to A (which is a row of data) If anyone could offer any help. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
row select
Moique,
Sure. Use the worksheet selection change event to feed the filter parameters to the autofilter for that table, along the lines of this, placed into the worksheet's codemodule: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub Range("B2:C8").AutoFilter Field:=1, Criteria1:=Target.Value End Sub HTH, Bernie MS Excel MVP "Monique" wrote in message ... For display purposes, I only want to see that row on that page though. Is that possible? "Bernie Deitrick" wrote: You could use the worksheet's selection change event to change a cell used by a VLOOKUP formula to extract the data related to Parameters. -- HTH, Bernie MS Excel MVP "Monique" wrote in message ... i have a workbook that has a Parameters page. Right now, all the information shows no matter the selection on the Control page. I want to make it so depending on the variable selected on the Control page, the Parameters just shows items related to the selection. Control -- user picks A Parameters -- only display things related to A (which is a row of data) If anyone could offer any help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |