Try this,
Private Sub updatemonth()
Sheets("Brand").Range("C1").Select
If ActiveCell.Value = "" Then
Do Until ActiveCell.Value = "Total"
ActiveCell.Value = "Month i want"
ActiveCell.Offset(1, 0).Select
Loop
Else
MsgBox "No job to run"
End If
End Sub
Regards
Shekhar Sharma
On Wed, Aug 31, 2011 at 11:14 PM, Jorge Marques <leote.w...@gmail.com>wrote:
> Hi friends i have an issue, i use this do loop to fill cells with a
> certain text, how i want to choose what i put in "Month i want" and write
> in columns C until C reaches the value "total", what i pretend is a
> inputbox where i choose what to write.
>
>
> i think i have to use dim as integer and them define the inputbox with
> that dim and then define a msg box to confirm but only have an example for
> printing.
>
>
> Private Sub updatemonth()
> Sheets("Brand").Range("C1").End(xlDown).Offset(1, 0).Select
> Do
> ActiveCell.Value = "Month i want"
> ActiveCell.Offset(1, 0).Select
> Loop Until ActiveCell.Offset(0, 4).Value = "Total"
> End Sub
>
> thank you a 1000 times in advance.
>
>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing
those you hold well"
"Before you judge another, think of your own last mistake."
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
