LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kenn74
 
Posts: n/a
Default Linked cells from ActiveX control

I have 64 combo boxes, all are using linked cells so that I can perform
functions based on the user's selection.

Although the values contained within each combo box comes from an array of
numerical data (formatted Number General), the linked cells contain the
correct value, although they are being formatted as Text. Even applying cell
formatting as Number (0 decimal places) does not seem to help. Anytime the
corresponding combo box is changed, it reformats the linked cell as text,
causing my formulas not to work.

Any help would be greatly appreciated.
Thanks!
 
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
conditional formating / linked cells? ET Excel Discussion (Misc queries) 7 December 7th 05 07:57 PM
How to count how many cells a linked cell group occupies Kanaski79 Excel Worksheet Functions 7 September 23rd 05 08:49 PM
Show cells have been read - linked ufo_pilot Excel Discussion (Misc queries) 0 August 5th 05 04:22 PM
Preserving hyperlinks in linked cells JulieW Excel Discussion (Misc queries) 1 February 24th 05 07:53 PM
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM


All times are GMT +1. The time now is 02:42 PM.

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"