Is an example: considering sheet1:
Sub TestButton()
Dim sht1 As Worksheet
Dim lastRow As Long
Set sht1 = Sheets(1)
lastRow = sht1.Cells(Rows.Count, 2).End(xlUp).Row + 1
sht1.Range("b" & lastRow) = sht1.[a1]
End Sub
rgds.
Basole
2014-10-06 16:39 GMT-03:00 Joe Coldwell <josephcoldw...@gmail.com>:
> Hi everone, I've been trying to figure out how to do this for a few days
> now, and decided to ask for help.
>
> I want to make a button macro that, when you click it, it displays a value
> of a cell in a diferent cell, and each time you click it it displays the
> cell below.
>
> *In other words:*
>
> I want to make a sheet that has a list in column B,
>
> When I click the Button I want "A1" to display "B1"
> When I click it a second time I wan "A1" to display "B2"
> When I click it a third time I want "A1" to display "B3"
>
> etc.
>
>
> This seems like it should be simple, but I can not for the life of me
> figure it out.
>
> If you'd like to help further, I'd like to make another button that
> reverses that to go up a cell, and a third that resets it back to "B1"
>
> Thanks a lot, I'd appreciate any help I can get.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
