Prompt Box

markpedro

New Member
Joined
Sep 25, 2003
Messages
27
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
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
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

Well-known Member
Joined
Oct 29, 2002
Messages
709
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

Legend
Joined
May 15, 2003
Messages
29,536
Something like this might get you started:
Code:
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

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456

ADVERTISEMENT

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

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Sep 25, 2003
Messages
27

ADVERTISEMENT

SLINKRN,

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

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
Hey Smitty,
5 bucks for a cup of coffee??! :eek: Man! We can get a whole gallon of gas for that! :unsure:

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! :devilish: )
Dan
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,100
Messages
5,768,095
Members
425,452
Latest member
htay44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top