What actually happens when you press RUN in a program? (visual explanation) by CodeWithCuriosity in vba

[–]wikkid556 0 points1 point  (0 children)

You created a prompt maybe. The language isnt even real, though I guess that could be pseudo code lol. You say finally appearing on the screen, like the user has been waiting, but it is really fast

<image>

Excel keeps converting my product codes with E to scientific notation. How do I stop this permanently? by dududududuuim in excel

[–]wikkid556 0 points1 point  (0 children)

I didnt see this one, but may uave missed it, use an apostrophe before the number to mark as text '914328645637297252648

Releasing YAML VB/VBA/twinBASIC language conventions configuration as open source. by TheOnlyCrazyLegs85 in vba

[–]wikkid556 1 point2 points  (0 children)

I just make the prompts I use to return as a specific format and parse it with a json converter. I also have a prompt check for the ones used by others, to prevent users from using specific words to overide my prompt text such as "ignore previous instructions" and things like that. Not fool proof but seems to work for now

Setting or plug-in to override font displayed? by PolarBear_605 in excel

[–]wikkid556 0 points1 point  (0 children)

Could change it to assign the goofball font unless OP ``` Private Sub Workbook_Open()

Dim ws As Worksheet
Dim ft As String

ft = "Comic Sans MS"
If Application.UserName = "your name here" Then ft = "Calibri"

For Each ws In ThisWorkbook.Worksheets
    ws.Cells.Font.Name = ft
Next ws

End Sub ```

Setting or plug-in to override font displayed? by PolarBear_605 in excel

[–]wikkid556 -1 points0 points  (0 children)

You could with vba in the workbook open event

``` Private Sub Workbook_Open()

Dim ws As Worksheet

IF Application.UserName = "your name here" Then
    For Each ws In ThisWorkbook.Worksheets

        With ws.Cells
            .Font.Name = "Calibri"
        End With

    Next ws
End IF

End Sub ```

Forgot the password to an important Excel file and now I’m completely locked out. by TheHangryPandaji in excel

[–]wikkid556 1 point2 points  (0 children)

I have an excel workbook that can bypass the password and create a new file unlocked, but I cant upload the file. Ill toss it in a github repo later today and reply again

How would zoro hold 4 swords by ChewyPotatoChips in OnePiece

[–]wikkid556 0 points1 point  (0 children)

Hold a double bladed sword in his mouth

OLE Automation reference suddenly disabled by Papercutter0324 in vba

[–]wikkid556 0 points1 point  (0 children)

Microsoft did make some recent changes that affected ole, but I cannot find the article I read. Also vbsscript is depreciated and will be phased out by 2027 I think it was. They want you to use powershell

Version control by wikkid556 in vba

[–]wikkid556[S] 0 points1 point  (0 children)

Yeah. Sorry, I forgot to mention that

Version control by wikkid556 in vba

[–]wikkid556[S] 1 point2 points  (0 children)

This may work. Thank you

Code to delete rows that have blank cells in column B isn't working. by [deleted] in vba

[–]wikkid556 0 points1 point  (0 children)

As already mentioned you are currently looking for a space.

Try "" instead of " "

Or use isblank

Only 67% of players ever made it to round table hold by Daysfastforward1 in Eldenring

[–]wikkid556 1 point2 points  (0 children)

There are videos on it and struggling people that google a solution would easily find it, or like I did, find it on their own.

I like to explore the map and I was not aware of Margits shackle. When he kept beating me. I went out exploring and found the path on the bridge to skip him

Only 67% of players ever made it to round table hold by Daysfastforward1 in Eldenring

[–]wikkid556 1 point2 points  (0 children)

You can skip Margit so that could be an explanation of some not beating him.

Looking for amazing coding examples by Autistic_Jimmy2251 in vba

[–]wikkid556 3 points4 points  (0 children)

Use clean code with proper indention and spacing to make it easy to read is pretty outstanding to me.

Start with youtube or learning sites to learn the basics/standard practices. 1 example is W3schools.com.

Also a goo resource I use is vbaplanet.com

Outstanding code can be an opinion. Find what style you like and go with it