How to use VBA to read a key value in Registry

I want to use VBA to read a value from an app-specific key that I have already added to the Registry (HKCU) using Regedit. It's a simple, single string value. I have found various code samples, snippets, and instructions; but so far I have not been able to adapt any of them to work in my application. I believe there is a fairly simple routine (2 or 3 lines) to do this, as long as the key is in HKCU. Does the key also have to be in a specific path in HKCU? If yes, I can put it there. I would be grateful to be provided with the code, or pointed to a web page with code and instructions.

Thanks in advance. I use Excel 2016, with fully up-to-date Windows10.

Thanks JBeaucaire,

I had been to both websites you show; I prepared the following code based on Live Journal's first snippet:

Please Login or Register  to view this content.

It returns "", can't find the key. When I comment out On Error the function crashes showing error code '-2147024894(80070002)' "Unable to open (specified key) for reading".
I have double checked the key that I added via Regedit. Can you tell from this info what I'm doing wrong?

Thanks

Thanks, Norie, that did it! Now how do I mark the thread as Solved?