It is not very good. I've used Bard, BingAi and ChatGPT to write VBA code. I can paste the same prompt into all three. ChatGPT usually gets it right. Bard rarely does without really breaking it down and explaining what I want like I am explaining to a 5 year old.