Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Activating a Userform in VB when changing Cells in Excel

How do I make a userform appear by changing the cell contents in Excel? I need to do this without using any command buttons or other VB objects, just by changing the cell value.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Activating a Userform in VB when changing Cells in Excel

Responded to yesterday's same question.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CTInt04" wrote in message
...
How do I make a userform appear by changing the cell contents in Excel? I

need to do this without using any command buttons or other VB objects, just
by changing the cell value.


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
Activating cells with checkbox KeyAdministration Excel Worksheet Functions 1 May 30th 08 02:14 PM
Dynamically Activating Cells Rob Excel Discussion (Misc queries) 5 June 5th 07 04:39 PM
Exception in Activating Subscription Cells Ostate Excel Discussion (Misc queries) 1 May 22nd 07 07:38 AM
Activating VB form by changing cells CTInt04 Excel Programming 3 June 30th 04 12:13 AM
Hide/Show modeless userform when activating/deactivating workbooks Jeremy Gollehon[_2_] Excel Programming 0 August 28th 03 11:05 PM


All times are GMT +1. The time now is 04:23 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"