Prompt Box

[markpedro]

I am attempting to create a prompt box (if available) that would prompt a user to enter a specific row to delete and move to another worksheet?

Thanks

 

[HalfAce]

Hi markpedro,
You haven't indicated how you want to fire this off, but a messagebox should do it.

In your code you could include this line at the appropriate place:
MsgBox "Please select the proper row to delete and then move to the worksheet I want you to."
(Or whatever you want it to say.) Chances are that all this could just be done with code instead of telling the user to do it.

This anything like what you're looking for?
Dan

 

[SlinkRN]

Can you give an example? What would the user be doing - you could make a command button that the user would click that says "delete entry" and then you could make that button pull up a form that would allow him to enter which row he wants deleted, then the code could move the user to the page you want or a page he enters. Is that what you had in mind?

 

[Smitty]

Something like this might get you started:

Sub CutMe()

    ans = InputBox("Please enter the row number to cut")
        Rows(ans & ":" & ans).Cut
    ans1 = InputBox("Please enter the sheet to copy to...")
        Sheets(ans1).Select
        ActiveSheet.Paste
    
End Sub

Hope that helps,

Smitty

 

[HalfAce]

Yup,
Slink & Smitty have both had more coffee than I have.
Something like those suggestions are what I was headed for.
Dan

 

[Smitty]

have both had more coffee than I have

Hey Dan! Yup, the Boss felt bad for making me work over the weekend, so he brought Starbucks this morning...At least I didn't have to pay for a $5 cup of coffee!

Smitty

 

[markpedro]

SLINKRN,

That is exactly what I am trying to accomplish......

 

[HalfAce]

Hey Smitty,
5 bucks for a cup of coffee??! Man! We can get a whole gallon of gas for that!

markpedro,
If you were to make the button SlinkRN suggests, and assign the code Smitty provided to it, you'd be all done I think. (And could go get some coffee! )
Dan

 

[markpedro]

Coffee is like our lifeline where I work...

Thanks for the help everyone

 

[markpedro]

One last thing,

I am drawing a blank as to how to create a message box...