Vba code for cell reference

[gdharsh]

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.

[elcaris]

Try these code:

Please Login or Register  to view this content.

[gdharsh]

Thanks 4 trying but there is not correct for my problem. Plz help me.

[royUK]

I can't understand what you mean.

[gdharsh]

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

[royUK]

Attach the file here using the Attachment button, your site won't let me download

[gdharsh]

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

[kroz]

try putting this in your button:

Please Login or Register  to view this content.

[gdharsh]

Thanks kroz and Forums Administrator. Thanks again.