RE: $$Excel-Macros$$ what is coding of previous and next button in excel

2010-08-23 Thread Dave Bonallack
. Date: Sun, 22 Aug 2010 14:25:55 +0530 Subject: $$Excel-Macros$$ what is coding of previous and next button in excel From: neil.jh...@googlemail.com To: excel-macros@googlegroups.com Hi Everyone, I make user form in excel. But I don't know how to run "Previous button and

$$Excel-Macros$$ what is coding of previous and next button in excel

2010-08-22 Thread neil johnson
Hi Everyone, I make user form in excel. But I don't know how to run *"Previous button and next Button" in *excel by making vba code. Please help . What is Syntax of this button ? I know only Syntax = dim lastrow lastrow = range("A65550").end(xlup).row+1 range("A" &lastrow).value = textbox1.text