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