View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PokerZan[_2_] PokerZan[_2_] is offline
external usenet poster
 
Posts: 1
Default Macro Won't Open up Userform


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