#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Userform

Hi

I am having trouble calling a userform from a module. What
am i doing wrong?

Form_Suppliers.show

TIA

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Userform

Edgar,

What specifically are you having trouble with? Do you get an
error message? Does the form show?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes" wrote in
message ...
Hi

I am having trouble calling a userform from a module. What
am i doing wrong?

Form_Suppliers.show

TIA



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Userform

It says 'Object Required' and the form doesnt show

TIA


-----Original Message-----
Edgar,

What specifically are you having trouble with? Do you

get an
error message? Does the form show?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes"

wrote in
message ...
Hi

I am having trouble calling a userform from a module.

What
am i doing wrong?

Form_Suppliers.show

TIA



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Userform

Is your userform name actually Form_Suppliers

Do you have code in the initialize event - is it causing an error.

--
Regards,
Tom Ogilvy

"Edgar Thoemmes" wrote in message
...
Hi

I am having trouble calling a userform from a module. What
am i doing wrong?

Form_Suppliers.show

TIA



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Userform

Edgar,

Is your form named Form_Suppliers?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes" wrote in
message ...
It says 'Object Required' and the form doesnt show

TIA


-----Original Message-----
Edgar,

What specifically are you having trouble with? Do you

get an
error message? Does the form show?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes"

wrote in
message ...
Hi

I am having trouble calling a userform from a module.

What
am i doing wrong?

Form_Suppliers.show

TIA



.





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Userform

Yes definately, i tried changing the name but this didnt
work as well. I imported the form from another sheet if
that would make any difference?


-----Original Message-----
Edgar,

Is your form named Form_Suppliers?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes"

wrote in
message ...
It says 'Object Required' and the form doesnt show

TIA


-----Original Message-----
Edgar,

What specifically are you having trouble with? Do you

get an
error message? Does the form show?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Edgar Thoemmes"

wrote in
message ...
Hi

I am having trouble calling a userform from a module.

What
am i doing wrong?

Form_Suppliers.show

TIA



.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA userform jcheko Excel Worksheet Functions 1 April 24th 08 08:38 PM
Userform to appear on top? capt Excel Discussion (Misc queries) 6 February 24th 08 02:53 PM
Userform Help in VBC Marcia3641 Excel Discussion (Misc queries) 1 July 23rd 05 12:10 AM
userform Tom Ogilvy Excel Programming 1 September 2nd 03 10:12 PM
userform Antonov Excel Programming 1 September 2nd 03 04:25 AM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"