I have a worksheet with 2000 rows.
I want to type my desire row no. in H2 Cell and create a command button 'GoTo' after H9.
I want to jump on (H2*64+4) ; when i click on goto command button.
please tell me VBA Code for this command button.
I have a worksheet with 2000 rows.
I want to type my desire row no. in H2 Cell and create a command button 'GoTo' after H9.
I want to jump on (H2*64+4) ; when i click on goto command button.
please tell me VBA Code for this command button.
Try these code:
Please Login or Register to view this content.
Thanks 4 trying but there is not correct for my problem. Plz help me.
I can't understand what you mean.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Sir, I have attached a link for my worksheet with problem.
In this sheet I want type Desire Date in 'H2' Cell.
For Example I type 5 then cursor moves on Date '5'
which is located on 'C228' = C & 4+(5-1)*56
and when I type 28 then cursor moves on Date '28'
which is located on cell 'C1516' = 4+27*56
where 4 & 56 is constant and multiplier number with 56 is less then 1 from desire date.
So plz check example sheet and give a code or solution for GoTo Command Button or something else for quick selection of Date.
Note: Formulas in this sheet will be replaced with there values upto 3.
link for file download:
http://filefactory.com/file/af5418d/n/diary_part_xls
Forward Message
Attach the file here using the Attachment button, your site won't let me download
Sir, I have attached a link for my worksheet with problem.
In this sheet I want type Desire Date in 'H2' Cell.
For Example I type 5 then cursor moves on Date '5'
which is located on 'C228' = C & 4+(5-1)*56
and when I type 28 then cursor moves on Date '28'
which is located on cell 'C1516' = 4+27*56
where 4 & 56 is constant and multiplier number with 56 is less then 1 from desire date.
So plz check example sheet and give a code or solution for GoTo Command Button or something else for quick selection of Date.
Note: Formulas in this sheet will be replaced with there values upto 3.
Download file from here
try putting this in your button:
Please Login or Register to view this content.
Thanks kroz and Forums Administrator. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks