dellehurley
Board Regular
- Joined
- Sep 26, 2009
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
Hi,
I'm sure this is simple but I cannot find the answer.
I have a userform which sends data to a database. If the checkbox is checked then it makes the cell bold. This is working well. My issue is with the edit function, this repopulated the userform so changes can be made. I cannot get the checkbox to check if the cell is bold, this is what I have
debug results are
Line 1= false (when it should be true).
Line 2, 1st section =Null and Line 2, 2nd part =True
what am I doing wrong?
Dannielle
I'm sure this is simple but I cannot find the answer.
I have a userform which sends data to a database. If the checkbox is checked then it makes the cell bold. This is working well. My issue is with the edit function, this repopulated the userform so changes can be made. I cannot get the checkbox to check if the cell is bold, this is what I have
VBA Code:
If shDB.Range("A2").Font.Bold = True Then
Me.cboxPriority1.Font.Bold = True
Else
debug results are
Line 1= false (when it should be true).
Line 2, 1st section =Null and Line 2, 2nd part =True
what am I doing wrong?
Dannielle