Hello,

I have created a UserForm for inputing data and I am trying to use
simple macro to open from a button on the sheet. I have done thi
before so I'm not sure why it isn't working. I am creating a module i
the spreadsheet with the following:

Sub OpenInputForm()
frmTrendScoreCard.Show
End Sub

When I click on it it says it is missing an object... Then runs th
DeBugger and highlights the "frmTrendScoreCard.Show" section.

While I have done this before, I'm by no means what I would conside
adept. If I need to add more inforfmaiton

TYIA,

PZa

--
PokerZa
-----------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...fo&userid=2348
View this thread: http://www.excelforum.com/showthread.php?threadid=47731

Are you 100% sure that your form is called 'frmTrendScoreCard'?

Not 'fmTrendScoreCard' or some other minor variation?

Simple but most likely!

Right-click the error line "frmTrendScoreCard.Show" and select Definition.
If VBA does not take you anywhere then the form name is probably spelled
wrong (happens all the time!!!)

"PokerZan" wrote:


Hello,

I have created a UserForm for inputing data and I am trying to use a
simple macro to open from a button on the sheet. I have done this
before so I'm not sure why it isn't working. I am creating a module in
the spreadsheet with the following:

Sub OpenInputForm()
frmTrendScoreCard.Show
End Sub

When I click on it it says it is missing an object... Then runs the
DeBugger and highlights the "frmTrendScoreCard.Show" section.

While I have done this before, I'm by no means what I would consider
adept. If I need to add more inforfmaiton

TYIA,

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=477310

I have double checked the name (even copied and pasted the name) and i
is still giving me the error #424 Object Required. I'm baffled..
:confused

--
PokerZa
-----------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...fo&userid=2348
View this thread: http://www.excelforum.com/showthread.php?threadid=47731

I have double checked the name (even copied and pasted the name) and it
is still giving me the error #424 Object Required. I'm baffled...



--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=477310

When I click on the definition as JNW suggested it pulls up the cod
behind my form... if that helps with anything

--
PokerZa
-----------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...fo&userid=2348
View this thread: http://www.excelforum.com/showthread.php?threadid=47731

Microsoft's website says the following: "This behavior can occur if the
references to the button are no longer valid because the menu context has
been switched to another document. "

I would make sure to also check the reference to the form. Do you have more
than one workbook open? Has the file name changed and affected the
reference? I really don't know what else to suggest other than double
checking the entries. In design mode, double-click the button to make sure
that it is referencing the right code.

Also, I couldn't tell from before, but make sure that the following code is
in a separate module and not the code for the sheet (you may have already
done this)
Sub OpenInputForm()
frmTrendScoreCard.Show
End Sub

I hope that helps. I've tried to recreate what you're saying and haven't
been able to at all. Never seen this before...

"PokerZan" wrote:


When I click on the definition as JNW suggested it pulls up the code
behind my form... if that helps with anything.


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=477310