Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro Button to Move to a Different Cell
I have a form, where, based on what Option Button the user clicks, should
display a different next question. In other words, if you click "Yes" and then press the "Submit Answer" button, you should be taken to an area named "Answer_A". If you click "No" and then press the "Submit" you should be taken to an area named "N". The "Submit Answer" button is assigned to Macro "Answer_Q1". I have my option buttons linked to cell J8 - "Yes" is 1, "No" is 2. Here's Macro "Answer_Q1": Sub Answer_Q1() If J8 = 2 Then Application.Goto reference:="N", Scroll:=True ElseIf J8 = "1" Then Application.Goto reference:="Answer_A", Scroll:=True End If End Sub When I click the "Submit" button, NOTHING happens. I tried changing the option buttons to a drop-down box (and appropriately changed the variables in the macro, natch), and still nothing happens. Thoughts? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro Button to Move to a Different Cell
This worked for me:
Sub Answer_Q1() If Range("J8").Value = 2 Then Application.Goto reference:="N", Scroll:=True ElseIf Range("J8").Value = 1 Then Application.Goto reference:="Answer_A", Scroll:=True End If End Sub Mike F "RJB" wrote in message ... I have a form, where, based on what Option Button the user clicks, should display a different next question. In other words, if you click "Yes" and then press the "Submit Answer" button, you should be taken to an area named "Answer_A". If you click "No" and then press the "Submit" you should be taken to an area named "N". The "Submit Answer" button is assigned to Macro "Answer_Q1". I have my option buttons linked to cell J8 - "Yes" is 1, "No" is 2. Here's Macro "Answer_Q1": Sub Answer_Q1() If J8 = 2 Then Application.Goto reference:="N", Scroll:=True ElseIf J8 = "1" Then Application.Goto reference:="Answer_A", Scroll:=True End If End Sub When I click the "Submit" button, NOTHING happens. I tried changing the option buttons to a drop-down box (and appropriately changed the variables in the macro, natch), and still nothing happens. Thoughts? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro Button to Move to a Different Cell
When I run it. NOTHING happens. No error messages, but no movement either!
"Mike Fogleman" wrote: This worked for me: Sub Answer_Q1() If Range("J8").Value = 2 Then Application.Goto reference:="N", Scroll:=True ElseIf Range("J8").Value = 1 Then Application.Goto reference:="Answer_A", Scroll:=True End If End Sub Mike F "RJB" wrote in message ... I have a form, where, based on what Option Button the user clicks, should display a different next question. In other words, if you click "Yes" and then press the "Submit Answer" button, you should be taken to an area named "Answer_A". If you click "No" and then press the "Submit" you should be taken to an area named "N". The "Submit Answer" button is assigned to Macro "Answer_Q1". I have my option buttons linked to cell J8 - "Yes" is 1, "No" is 2. Here's Macro "Answer_Q1": Sub Answer_Q1() If J8 = 2 Then Application.Goto reference:="N", Scroll:=True ElseIf J8 = "1" Then Application.Goto reference:="Answer_A", Scroll:=True End If End Sub When I click the "Submit" button, NOTHING happens. I tried changing the option buttons to a drop-down box (and appropriately changed the variables in the macro, natch), and still nothing happens. Thoughts? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro Button to Move to a Different Cell
Scratch that. I started from the beginning, and it works fine.
Hmmm..... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button macro to move/delete active row | Excel Discussion (Misc queries) | |||
move to a different cell with the arrow button. | Excel Discussion (Misc queries) | |||
Move Macro Button on Sheet to a toolbar | Excel Discussion (Misc queries) | |||
Macro to Move Excel Button | Excel Programming | |||
How to move a button with an assinged macro | Excel Programming |