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: 22
Default How to enter a value in a cell

I've tried this macro and it works:
Sub temp()
Range("Comm!f7").Value = 0
End Sub

But what I need is a function. This one doesn't work, I get
#VALUE!:
Function temp1()
Range("Comm!f7").Value = 0
End Function

And this doesn't work either:
Function temp1()
temp
End Function

There could be another way, a better one, but much too
difficult for me. What I am trying to do is to erase from
memory all the values pertaining to Sheet1, as soon as any
of its cells is modified by the user (the values are
preserved in memory as public arrays). By searching Google,
I found references to Worksheet_Change. Can someone help me
with that too, please ?

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
Vlookup if #N/A then enter enter data in cell I4 duketter Excel Discussion (Misc queries) 3 March 11th 08 09:08 PM
Enter multiple numbers in a cell so total shows when enter keypres newbie Excel Worksheet Functions 2 August 19th 07 12:23 PM
Auto enter date when data in enter in another cell Brian Excel Worksheet Functions 5 December 7th 06 06:44 PM
How to force <enter to behave like <alt + <enter within a cell luckyinky Excel Programming 3 July 28th 05 04:47 PM
how do I enter a RETURN (Enter) in a cell in EXCEL2003 Micheline Excel Discussion (Misc queries) 5 April 14th 05 10:00 PM


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