Digital photography school have a post on alternatives to buying a dedicated macro lens (some of these work with some compact cameras too)
Also worth mentioning is their post with some links to guides on taking photos of water drops
These are what I came up with when I first tried – I like the idea of drops hitting an apple though
1 Response to Alternatives to Buying a Dedicated Macro Lens for your DSLR