Code to check if form object (shape) exists not working correctly?

**Belinea2010** · 10-13-2018, 10:27 AM

Hi

I am using Excell 2007 and I have a macro that performs various tasks.

One of these tasks is to look and see if an Form Option Button named OptionButton1 exists
and if it does it deletes it, if it does not then it displays a message box.

From researching I have been able to come up with the code below thanks to google searches
but when I run it with the option button on the worksheet it brings up the message box which
is wrong as the option button DOES exist.

Can someone kindly suggest where I am going wrong or if there is a better way?

Please Login or Register  to view this content.

**davesexcel** · 10-13-2018, 10:43 AM

Very high odds that it is spelled "Option Button 1" not "OptionButton1"

**Belinea2010** · 10-13-2018, 10:46 AM

Originally Posted by davesexcel

Very high odds that it is spelled "Option Button 1" not "OptionButton1"

Hi Dave

When the Option Button is created by a different macro the object name property is set to OptionButton1.

Please Login or Register  to view this content.

**daboho** · 10-13-2018, 11:36 AM

try this

Please Login or Register  to view this content.

**Belinea2010** · 10-13-2018, 12:25 PM

daboho,

Thank you for your reply.

Your code is returning every option button and group box on my worksheet and giving the message that they do not exists when they do?

**daboho** · 10-13-2018, 01:28 PM

Originally Posted by Belinea2010

daboho,

Thank you for your reply.

Your code is returning every option button and group box on my worksheet and giving the message that they do not exists when they do?

Change to

Please Login or Register  to view this content.

**Belinea2010** · 10-13-2018, 02:03 PM

Hi daboho

I really appreciate you taking the time to help me.

The new code is now only looking for the Option Button and displays the Has Exists message if the option box DOES exist which is but
if the option box does NOT exist the code does not display the Not Exists message?

**davesexcel** · 10-13-2018, 03:48 PM

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.

To add a file to a post

Code to check if form object (shape) exists not working correctly?

LinkBack

Thread Tools

Rate This Thread

Display

Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Re: Code to check if form object (shape) exists not working correctly?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA: How to check if an object already exists in worksheet or module

[SOLVED] Compile error: Member already exists in an object module...Trying to create a form

[SOLVED] Member already exists in an object module form which this object module derives error

Worksheet exists........function not working correctly.

check if shape exists, then...

check if shape Exists

Check if a Form item exists.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions