Runtime error
 

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

Runtime error
 

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

Runtime error
 

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

Runtime error
 

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson

Runtime error
 

Since you mentioned that, I came across some code that was using the Call
Statement. I recoded this so it doesn't use the Call Statement on a sub.
The code runs now, but I'm not sure why Call would cause a runtime error.

"Dave Peterson" wrote:

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson

Runtime error
 

I zeroed it down. It wasn't the .Show problem. It was .DisplayWorkbookTabs.
I got that code by recording a macro, then copying from the Module.

Is there an Add-In or Reference I need to allow ".DisplayWorkbooksTabs."

"Dave Peterson" wrote:

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson

Runtime error
 

Nope. That's built into excel.

What was the problem when you used it?

aftamath77 wrote:

I zeroed it down. It wasn't the .Show problem. It was .DisplayWorkbookTabs.
I got that code by recording a macro, then copying from the Module.

Is there an Add-In or Reference I need to allow ".DisplayWorkbooksTabs."

"Dave Peterson" wrote:

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson


--

Dave Peterson

Runtime error
 

I was trying to use a specific worksheet. I changed the worksheet object to
ActiveWindow.DisplayWorkbookTabs instead of
Worksheets(Index).DisplayWorkbookTabs

"Dave Peterson" wrote:

Nope. That's built into excel.

What was the problem when you used it?

aftamath77 wrote:

I zeroed it down. It wasn't the .Show problem. It was .DisplayWorkbookTabs.
I got that code by recording a macro, then copying from the Module.

Is there an Add-In or Reference I need to allow ".DisplayWorkbooksTabs."

"Dave Peterson" wrote:

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson


--

Dave Peterson

Runtime error
 

Sometimes VBA's help is nice.

If you search for that property, then click the "Applies to" link, you'll see
that it applies to the window object.



aftamath77 wrote:

I was trying to use a specific worksheet. I changed the worksheet object to
ActiveWindow.DisplayWorkbookTabs instead of
Worksheets(Index).DisplayWorkbookTabs

"Dave Peterson" wrote:

Nope. That's built into excel.

What was the problem when you used it?

aftamath77 wrote:

I zeroed it down. It wasn't the .Show problem. It was .DisplayWorkbookTabs.
I got that code by recording a macro, then copying from the Module.

Is there an Add-In or Reference I need to allow ".DisplayWorkbooksTabs."

"Dave Peterson" wrote:

Did you look to see if there was any other thing that used FormHome as its name?

aftamath77 wrote:

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

"Jim Thomlinson" wrote:

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

--
HTH...

Jim Thomlinson


"aftamath77" wrote:

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson