Forum Discussion

Copper Contributor

Jul 23, 2025

Solved

VBA - EXCEL - Userform

Hello there, I have a weird question.
I'm creating an excel file to manage a different list, everything works as it should but ...
I use what are called 'userforms', now my question, how do I change the background colour of the titel line. Foreground and font are no problem it's just the background.
Any help is welcome. Thanks in advance. Andy

developer

excel

Macros and VBA

AndyPe
Jul 24, 2025
Hi JK,

Thanks for your reply but I think I have solved my own problem.
I had a look at personalised themes in windows and colours and now it works.
Regards, Andy

4 Replies

JKPieterse
Silver Contributor
Jul 24, 2025
As far as I'm aware, the title bar color and font is controlled by Windows. There are several options to change the appearance of a userform using Windows API functions, but that is not for the faint of heart!
Let me know if you want to learn more about this.
- AndyPe
  Copper Contributor
  Jul 24, 2025
  Hi JK,
  
  Thanks for your reply but I think I have solved my own problem.
  I had a look at personalised themes in windows and colours and now it works.
  Regards, Andy
- AndyPe
  Copper Contributor
  Jul 24, 2025
  Thanks JK.
  
  I don't think I have ever used API, if it's not too difficult maybe you can put me on my way.
  Regards, Andy
ArkikZero
Iron Contributor
Jul 24, 2025
Just insert a user form in the VBA editor and bind the control events.