Hash (#) Key and other function pieces

Originally Posted by Damask

Hello all,

These are going to seem like very basic things to ask, but I've searched without result so far. I'm a programmer but am new to VBA and there are a couple of things that get me.

I'm trying to understand the following Function:

Please Login or Register  to view this content.

QUESTIONS:
1. On line 2, what does the '#' character do?

ANSWERED / FOUND INFORMATION:
2. Does the 'Variant' datatype imply any type of data?
Declares any kind of variable automatically.
3. It looks like I don't have to explicitly call return - is this always the case?
Oversight on my behalf - functionName = returnData (I.E. dGet = ... )


Thanks to any who can help shed some light!
- Damask -

Did you answer this? - (I have no idea) but I would point out that, if you enter that as a function, and then start to enter =dget(
in a cell, you are prompted for 'Database,field,criteria' under the formula bar.

dunno if that is any clue.
---

Thanks, but I haven't answered this yet.

I still don't know what the hash (#) character on line 2 does.

Please Login or Register  to view this content.

- Damask -