LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 61
Default Using linked cell to change value in combo box

Hi really helpful people

I have a combo box created using control toolbox that is linked to a
worksheet cell. When the value in the combo box is changed it triggers macro
that works well and the value in the linked cell also changes. When I
manually change the value in the cell, the combo box value changes and that
triggers the macro. This also works well.

Here's the but..
When I change the linked cell value within a macro, it does what it is
supposed to but then bombs. Excel sends me this nasty message that it can't
handle what I want to do; it has run out of memory, etc.

Any idea what might be going wrong?

--
eugene
 
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
Listbox linked cell does not change Dkline Excel Worksheet Functions 2 May 5th 07 03:57 PM
How to force a cell value to change if Linked cell moves? EagleOne Excel Discussion (Misc queries) 2 December 6th 06 03:32 PM
Combo Box doesn't display text in linked cell Broadband Al Excel Programming 0 January 21st 06 05:49 PM
Change sheet name on linked cell by dropdown box Mikeice Excel Worksheet Functions 12 June 11th 05 08:45 AM
copying text via linked cell from combo box to macro code pagelocator Excel Programming 0 November 16th 04 09:04 AM


All times are GMT +1. The time now is 08:19 AM.

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

About Us

"It's about Microsoft Excel"