Random number with poisson and lognorm distribution in excel

I need to create a monte carlo simulation in excel with vba, and for that i require

• a random number with poisson distribution
• a random number with lognorm distibution
• and repeat that 10000 times

could you guys help me with that?

thanks in advance