Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing the active cell
After making a selection within ComBoBox7 I would like to post data to the
row selected using Commandbutton1. Cell $a$4 contains the list index address Code should look something like this Private Sub CommandButton1_Click() Dim rngcell As Excel.Range If TypeName(ActiveSheet) = "Worksheet" Then Set rngcell = ActiveSheet.Range("$A$4") 'Cell $A$4 contains a cell address rngcell.Select 'make rngcell the active cell End If ActiveCell.Offset(0, 3) = TextBox13.Value End Sub -- Jim O |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing the active cell
Do you mean?
Private Sub CommandButton1_Click() Dim iRow as long iRow = Application.Match(combobox1.value,Range("A1:A100") ,0) Cells(iRow,"A").Seelect End Sub -- HTH Bob Phillips "Jim O" wrote in message ... After making a selection within ComBoBox7 I would like to post data to the row selected using Commandbutton1. Cell $a$4 contains the list index address Code should look something like this Private Sub CommandButton1_Click() Dim rngcell As Excel.Range If TypeName(ActiveSheet) = "Worksheet" Then Set rngcell = ActiveSheet.Range("$A$4") 'Cell $A$4 contains a cell address rngcell.Select 'make rngcell the active cell End If ActiveCell.Offset(0, 3) = TextBox13.Value End Sub -- Jim O |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing the active cell
-- Jim O "Bob Phillips" wrote: Do you mean? Private Sub CommandButton1_Click() Dim iRow as long iRow = Application.Match(combobox1.value,Range("A1:A100") ,0) Cells(iRow,"A").Seelect End Sub -- HTH Bob Phillips "Jim O" wrote in message ... After making a selection within ComBoBox7 I would like to post data to the row selected using Commandbutton1. Cell $a$4 contains the list index address Code should look something like this Private Sub CommandButton1_Click() Dim rngcell As Excel.Range If TypeName(ActiveSheet) = "Worksheet" Then Set rngcell = ActiveSheet.Range("$A$4") 'Cell $A$4 contains a cell address rngcell.Select 'make rngcell the active cell End If ActiveCell.Offset(0, 3) = TextBox13.Value End Sub -- Jim O Thank You I was going about the task totally wrong manner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing an active cell's content from another sheet. | Excel Worksheet Functions | |||
Referencing cell in active row | Excel Worksheet Functions | |||
referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
Referencing cells on non-active sheets | Excel Programming |