User Profile
Ezio-de-Pazzi
Brass Contributor
Joined Oct 02, 2022
User Widgets
Recent Discussions
Re: UserForms are getting strange, please help.
Gosh, I finally figured it out. Turns out it all comes from the 64-bit Office. I tried to uninstall my office then reinstall 32-bit and it works PERFECTLY. >_< I mean, come on Microsoft. It's 2022, I've been deploying 64-bit office to my colleague since 2016. And I don't regret it at all cause 64bit is sensible faster than 32bit to my workflow. Guess the best workaround would be Call .font. Italic = false at others module. Thanks for your response ~1.9KViews0likes1CommentUserForms are getting strange, please help.
This must be the weirdest phenomenon I've ever faced. Normally in Userform.ListBox.Font.Italic should works just like a range. Private Sub UserForm_Initialize() 'this would works as expected UserForm1.ListBox1.RowSource = "Sheet1!A1:A3" UserForm1.ListBox1.Font.Italic = True UserForm1.ListBox1.Font.Italic = False End Sub But see these two samples below. Private Sub UserForm_Initialize() 'this will NOT works! Just because i assigned a range variable. HOW STRANGE 'Notice the list is stil italic even if i set .Italic = False Dim test_rng As Range Set test_rng = [b5] UserForm2.ListBox1.RowSource = "Sheet1!A1:A3" UserForm2.ListBox1.Font.Italic = True UserForm2.ListBox1.Font.Italic = False 'MsgBox UserForm2.ListBox1.Font.Italic 'you can uncomment this line to check .Italic property, it's still TRUE End Sub Private Sub UserForm_Initialize() 'this will NOT works same! Because i assigned wildcard characters combined with textbox value to a variable. GOSH STRANGE. 'Notice the list is stil italic even if i set .Italic = False Dim test_str As String test_str = UserForm3.TextBox1.Value & "*" UserForm3.ListBox1.RowSource = "Sheet1!A1:A3" UserForm3.ListBox1.Font.Italic = True UserForm3.ListBox1.Font.Italic = False 'MsgBox UserForm3.ListBox1.Font.Italic 'you can uncomment this line to check .Italic property, it's still TRUE End Sub The codes self-explained. It just doesn't make any sense! how could possibly assign a range variable or wildcard+textbox value affects the italic property of listbox. And the most weird thing is to fix this, just assign italic property in other module. Call fixed ------------------ Sub fixed() UserForm3.ListBox1.Font.Italic = False End Sub I have uploaded a sample file to clarify the issue. Please leave any thoughts below ...Solved1.9KViews0likes5CommentsRe: Excel marco has been blocked when I'm using the excel in Onedrive!!
SangNguyen That's weird. Cause from what I've heard, it's supposed to be fixed by adding the onedrive path to trusted location. According to the articles below: https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216 https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#block-macros-from-running-in-office-files-from-the-internet https://learn.microsoft.com/en-us/deployoffice/security/trusted-locations Office will 1st check the file whether it in the trusted location or not, then decided to proceed the procedure or just full green. I suggest you manually remove the MotW (Mark of the Web) just for a test. If it runs normally, then it must be some mistake about your Trusted Location or Trusted Centre. Please double check them. If the issue stills, perhaps you need to check the Office program file integrity because it should be fine by design.1.3KViews0likes0CommentsRe: excel how to display table with list of members
bbsin There is no need to manually set every filter function. Since there are relative references to table number, you could easily complete every table sheet by just copy and paste it. And you don't have to reference one column in every filter function. Below should be better. =FILTER(List[[Guest Name]:[Catoegry]],List[Table '#]=I9)4.7KViews0likes1CommentRe: excel how to display table with list of members
bbsin please check this if I got your point. Cause like L z. said it really confused me for a long time. It's pretty easy with the FILTER function. =INDEX(FILTER($A$3:$C$26,$C$3:$C$26=F3),SEQUENCE(ROWS(FILTER($A$3:$C$26, $C$3:$C$26=F3))),{3,1}) I strongly recommend you to use Excel Table to structurize data, this way it could automatically resize the data range if you add. Plus, the function would be more understandable. =INDEX(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3),SEQUENCE(ROWS(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3))),{3,1})4.6KViews0likes0CommentsRe: Excel formulas
A B C 1 test4 four orange 2 test5 five white 3 test8 eight green 4 test7 seven orange 5 test9 nine silver 6 car ten black 7 test6 six green 8 test2 two green 9 test3 three orange 10 test1 one green If the data preset is like above, than your target function will be : =XLOOKUP($I$3&$J$3,$C$2:$C$11&$D$2:$D$11,$B$2:$B$11,"NA",0) Una_McCrossan1.6KViews0likes0CommentsRe: zip code
Samon1900 It suppose to. Because excel trying to identify your zip code as a numerical data. Thus, any 0 in prefix would be meaningless, so excel clear it automatically. Solution is very simple. Just change your cell format to Text. This way excel would identify your zip code as a string data.1.1KViews2likes0Comments
Recent Blog Articles
No content to show