VB Intellisense

Hi All,
I'm here with couple of questions,

1.How we can implement intellisense(Quick info,Parameter info) when i enter my own function in a VB6 Text box? could anyone suggest any activeX control with this functionality?

2.How we can apply color to a particular letter?For example,if we type a combination of function in a excel cells only brackets"()" appears in different color.I want to implement this functionality for vb text box.

Code:

---

SUM(K9:K12+(AVERAGE(N7:N17)))

---

Thanks in advance...

For number 2, I suggest you use the RTB (Rich Text Box) component.

You can open the components dialog by pushing CTRL + T in the VB IDE.

Thanks Zach for your reply,
If you suggest me how to apply color to a particular letter say for example "(" in the text, it will be helpful to me.because I'm using my own functions.when i enter the function the bracket color should change to another color(please refer the code part..).



thanks.....

For the intellisense, where is what will be displayed stored?

I have specific syntax for each of my own function.But no idea how to store :confused: .I believe , i can save this in an array as a text in a class module and compare the strings and display.if you have any suggestions please let me know.


Thanks,
Felix

That would be one way....of course, that means that the messages would be hard coded into your array. If you need to add more messages to you would need to modify the source and recompile and redistribute.

You could store them in a database. The would necessarily require recoding, but it would require a DB call each time you wanted to display a new message.

So, there are advantages and disadvantages to both approaches. Which one makes the most sense to, and for, you?

Array approach is better for me.Since this code will be part of my ActiveXDll.But i'm not sure how to implement this? ANY SUGGESTIONS Hack?

I'm in progress in implementing autocomplete,but no idea about quick info and parameter info.