Unable to add OK/No button to existing Msg Box.

**Ravana** · 09-21-2014, 02:32 AM

Hi! Everyone

I have this customized welcome message in Excel 2010 and I would like to add Ok and Cancel button with a message "Do you wish to Continue?" below my customized message.

If Ok, then enter the workbook and if Cancel then close the workbook.

Please Login or Register  to view this content.

Any help would be grateful. Thanks in anticipation to all.

**HaHoBe** · 09-21-2014, 02:37 AM

Hi, Ravana,

welcome to ExcelForum. Please have a look at Forum Rule #3 and wrap your procedure with code-tags as requested there.

Ciao,
Holger

**HaHoBe** · 09-21-2014, 02:50 AM

Hi, Ravana,

maybe like this:

Please Login or Register  to view this content.

So any non authorized personal will choose no - I pretty much doubt that and I would build on Environ("Username") and a lookup table for allowance or a folder where entry is restricted by Operating System.

Ciao,
Holger

**Ravana** · 09-21-2014, 03:02 AM

Hello Holger,

Thanks for the prompt reply. However there is no message box being displayed using the code you have replied.

I am a novice to vb and hardly know any basics of vb. So I am relying on this forum to meet my needs.

Hope, Sure forum helps me.

**HaHoBe** · 09-21-2014, 03:08 AM

Hi, Ravana,

you asked to add a yes-no button to the code not to make it work: any action for the button will only be valid from 19:00 to 23:59 per day as you check the current time where hour should be greater than 18.

Ciao,
Holger

**Ravana** · 09-21-2014, 03:41 AM

Hi Holger,

Sorry if I wasn't clear about what I needed. Let me explain it to you.

I want a display message stating time and date when it is being opened.Then in the next line Good Morning/Good Afternoon/Good Evening/Good Night depending upon the time of opening the file.

And then in next line something like Welcome Mr./Mrs. "System User" to the "current workbook name" (without extension).

Thereafter a Custom disclaimer message and below that "Do You Wish to Continue?" and below a 'OK' and 'No' buttons which work. If pressed Ok then user can enter the workbook. If No, then workbook closes.

Hope I made myself clear.

Can you help me out with this.

Thanks in anticipation.

**HaHoBe** · 09-21-2014, 04:52 AM

Hi, Ravana,

using a MsgBox iot will be impossible to feature OK and No as this combinartion isn´t available there (either OK and CANCEL or YES and NO). Or you build your own UserForm to feature this combination.

You might adapt the times for the messages:

Please Login or Register  to view this content.

Still not authorized personal may enter the workbook for authorized personal only if they click OK...

Ciao,
Holger

**Ravana** · 09-21-2014, 07:05 AM

Hi Holger,

This will do for me. Thanks a ton..!!

**Ravana** · 09-21-2014, 12:36 PM

Hi Holger,

As u said "Still not authorized personal may enter the workbook for authorized personal only if they click OK..." - is there anyway that if I click on Yes then it shall direct to another box asking for password. Is this possible?

Thanks in anticipation.

**HaHoBe** · 09-21-2014, 02:31 PM

Hi, Ravanna,

sure but using an InputBox will not mask the password when entered, and you would need to protect the VBA-project to make it harder to view the password. I suggest you have a look at at using UserForm where you may mask the entry to a textbox instead of working with API for an InputBox.

Please Login or Register  to view this content.

Please note that you would have to swap the Select Case for the time entries in order to get a different message than Good Monring.

Ciao,
Holger

**Ravana** · 09-21-2014, 04:05 PM

Heah Holger !

Thanks for being so generous and taking time to reply me. Your codes work fine always. This helped.

As I said I am a very very beginner to vb, I don't know how to use any user forms. I just search the net and find help for the codes I needed time and again. As you said password can't be masked using it in this way, is there a workaround to mask the password? If so can you help me out?

Thanks a ton !

**HaHoBe** · 09-21-2014, 11:51 PM

Hi, Ravana,

Originally Posted by Post #10

... instead of working with API for an InputBox.

Since you claim to be new to VBA please believe me that the easier way is to use a UserForm in VBA.

Ciao,
Holger

**Ravana** · 09-22-2014, 12:36 AM

Heah Holger,

How to use UserForm to achieve my purpose i.e. to get all the display message as well password box with masking?

**HaHoBe** · 09-22-2014, 01:02 AM

Hi, Ravana,

code in ThisWorkbook:

Please Login or Register  to view this content.

Code behind frmPassword:

Please Login or Register  to view this content.

Ciao,
Hoilger

Unable to add OK/No button to existing Msg Box.

LinkBack

Thread Tools

Rate This Thread

Display

Unable to add OK/No button to existing Msg Box.

Re: How to add OK/No button to existing Msg Box

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Re: Unable to add OK/No button to existing Msg Box.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using VBA to add 1 to an existing value when button is clicked

[SOLVED] Userform Button to Add Data to an Existing Table

How can i add a button to existing ribbon

Check Existing Button

Adding Code to an Existing Command Button with VBA

Bookmarks

Bookmarks

Posting Permissions