I need the VBA codes for those functions.

Exercises 1. Write function to calculate sum of every third number from string; 2. Write function to replace numbers with text from string; (example: 1asd2faazioneasdtwofaazseven) 3. Ask for some word, replace the letters (a,u,i,o,e) with triple letters. You MUST use ASCII values. (example: Computer Cooompuuuteeer). 4. Ask to input sentence. Count the words in sentence. 5. Ask for name and surname. Change first letter of name and surname to capital letter. 6. Generate 10 random numbers (range 1-100) and write each number to different rows of column A. Then read the numbers from cells. If number> 50 write it to column B, else column C. 7. Ask for name, spell the name by letters, change to opposite size (small to large, large to small) and write it to different cells (one cell = one letter); example: AB 1 IVAN -NM