[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Visual Basic code for a Stock ticker [part 1]

PureBytes Links

Trading Reference Links

 
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<STYLE></STYLE>

<META content='"MSHTML 5.00.0910.1309"' name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV>This is a re-send of earlier send mail, and as it did not arrive at the 
List-server,<BR>have had to split the mail in 2 seperate mails(part 1 and part 
2).<BR><BR>&gt;One problem in Excel -- there is no place to store &quot;in 
cell&quot; code bits and<BR>&gt;pieces for future 
reference.<BR>&gt;<BR>&gt;Maybe someone can think of a simple library type 
access system. I just store<BR>&gt;them on emails that I send to myself. Pretty 
primitive?<BR>---------------------------------------------------------------<BR><BR>You 
can have in a cell:<BR>&nbsp;-the cell's formula itselve as printed 
text<BR>&nbsp;or<BR>-the cell's formula outcomes as results<BR>&nbsp;<BR>both 
are ASCI-text, but treated differently(eg one is invisable / hidden) and 
choice<BR>is users. It requires for you to make the cell's formula to be the 
cell's definite text.<BR>What you will have to do then is to &quot;convert&quot; 
the formula to displayed text, much<BR>like the formula's outcome(s) are 
displayed text .<BR><BR>Check it in the Excel's Help files (if I'm not mistaken 
it requires for you to apply<BR>the Text function or one of the functions like 
it), I am sure it is given somewhere<BR>in the subjects &quot;funtions&quot; or 
&quot;conversion&quot; or &quot;text&quot; part of the Help.<BR></DIV>
<DIV>Or see the attached Microsoft Tips part-1 
(cool.html).<BR><BR>Regards,<BR>Ton Maas<BR><A 
href="mailto:ms-irb@xxxxxx";>ms-irb@xxxxxx</A><BR><BR><BR><BR>&nbsp;<BR>----- 
Original Message ----- <BR>From: Walter Lake &lt;<A 
href="mailto:wlake@xxxxxxxxx";>wlake@xxxxxxxxx</A>&gt;<BR>To: Metastock bulletin 
board &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;<BR>Sent: 
vrijdag 12 maart 1999 21:13<BR>Subject: Visual Basic code for a Stock 
ticker<BR><BR>&gt;snip----------------------------------------<BR></DIV></BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\cool.htm"