Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a row below a combobox determined cell
I have a list array named electrical that has all the prices for the items i
use. I have a prompt box to insert a new item . I want it to insert right below the category name that is determined by the combobox then copy formulas from a generic row so the calculations are inputed. I can't seem to figure out how to reselect the row that i just inserted it . Private Sub CommandButton1_Click() Dim cell As Range Dim SELECTEDCELL As Range For Each cell In Sheet7.Range("electrical") If PromptInsertItem.Category.Value = cell.Value Then cell.Offset(1, 0).Insert SHIFT:=xlDown End If Next Range("A18:x18").Select Selection.Copy ActiveSheet.Paste PromptInsertItem.Hide End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert # of Rows determined by cell | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Getting a value from a cell that is determined by a formula | Excel Discussion (Misc queries) | |||
Look up sheet name determined in cell | Excel Programming | |||
Inserting a combobox | Excel Programming |