what is the best thing to shoot macro? (water, wildlife ect)
A camera that can do the macro that you are looking for. Sounds obvious right, but it is not. Any camera can do some kind of macro.
Are you looking for a 1:1 magnification, or greater or a camera/lens combination that lets you shoot very close up.
If you are looking for a 1:1 then I don't think compact point and shoot cameras have this ability so you need to look at a DSLR with a dedicated macro lens. If you are just looking to get very close then try this test in your own home:
Go get a small item from around the house. It can be anything you like, a watch, a key, a teaspoon, a pea or a sweetcorn even.
Now place that item on a table in front of you. Get your compact camera and place the setting onto MACRO mode. It is usually a dial or setting of a tulip flower.
Focus on the item, get as close as you can to the item without the item getting blurred out. You will find the close focusing limit of the camera when you get so close that the camera cannot focus on it and create a sharp image. Another thing to keep in mind is that not all of the image will be in focus. Maybe only a small part of it. So don't confuse yourself and think it has reached its focus limit. I won't go into why this happens now, suffice to say it is to do with the "depth of field" at close distances.
Now take the picture, many of them, at different angles and distances to your subject. Load them on a computer and then see if this size of the object is big enough, close enough, for you. If it is then great!
If not then you may want to consider another camera.
Like stated, not if you have good light so the shutter speed on the camera is fast enough to stop "camera shake". Your hand holding technique will also matter. So test this too. Take the example above. Take a picure in nature light, then add a table lamp to illuminate further, try shooting near the window, try shooting in a slightly darker area of the room. See how the shutter speed changes. The more the light, the faster the shutter speed will be.
Now try it in your garden on some flower heads or any type of flora. Get as close as you can so some part of the item is in focus and take some pictures. When you review them on your computer, if they are sharp enough (taking into consideration the Depth Of Field) then your hand holding technique is fine.
is it ok (do i get same affect) to use a kodak digital?
What is the model number of your camera? Try out the tests I outlined above, they will set you on the road and start the learning process too.
Have fun!
im very gr8ful