Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default keep formula after typing in a value in a excel cell

Hi there,

my problem is, that i need something like:

there is a function in a excel-cell (for example '=setvalue("sqlserver",
"DB", "table")').
now i type in a value (for example 100) then the function "setvalue" must
write this value
(100) in the server, db and table from the parameters. after leaving the
cell the formula
is still the same and only the value 100 ist visible for the user. and if i
go back to the
cell than i can see the function in the menubar.

there is a product from applix (TM1) and they did it. the problem is, that
the souce code
is protected ;)

Is there anyone who has an idea or know how to handle it !?

thanks for your help!
Henning





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
How do I add typing instructions to an Excel cell? wjs2ps Excel Discussion (Misc queries) 4 April 2nd 23 08:39 PM
typing the date in a cell in excel and ###### comes up instead Lisa Excel Discussion (Misc queries) 6 August 9th 07 01:00 AM
How am i able to view the formula bar as I am typing in a cell? Kara Excel Worksheet Functions 1 January 25th 07 09:09 PM
can excel choose a name from a list when I am typing in a cell madisonville Excel Worksheet Functions 1 June 28th 06 03:28 AM
Excel 2000 insists on typing a formula Mr.PC Excel Discussion (Misc queries) 4 April 19th 05 05:02 PM


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