Most chat bots are developed for the web, social media, or mobile. Developing a chat bot in Excel is an unusual platform.
I'm not sure the capabilities of VBA, but to support avatars and speech it would require:
- HTTP access
- audio support
- video support