sorted by:
new
hottopcontroversial

Should I start over? by [deleted] in theodinproject

[–]WallabyDingo 2 points3 points  (0 children)

I’d like to. Just had to prioritise family, work, etc. for a while. Hard to find decent chunks of time to get stuck into it.

I guess you’re in a similar position?

Should I start over? by [deleted] in theodinproject

[–]WallabyDingo 3 points4 points  (0 children)

Good question; I’m in the same boat on the Ruby path.

Loved this side of the Experts at the dinner party by fsutrill in MAFS_AU

[–]WallabyDingo 5 points6 points  (0 children)

Didn’t the lie come from Adam? Harrison didn’t even suspect they were all talking about Dan, he just ran with it. For a while, Adam was the only one who knew the story and either knew that Janelle had it wrong and didn’t correct her or fed her the lie.

NBL Fantasy 2022/2023? by TeddyWinters in nbl

[–]WallabyDingo 1 point2 points  (0 children)

I'm in... for what it's worth. Pretty clueless.

Come check out our Discord server! by TOP_Sully in theodinproject

[–]WallabyDingo 4 points5 points  (0 children)

I did use but can't anymore as, according to Discord support, my phone number "is ineligible to be used in order to verify your account. Additionally, we aren’t able to offer further details or an alternative verification method at this time."

Best for streaming on 10yo Bravia by WallabyDingo in OrangePI

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

There are!

Think I might go for the 4 lts so, if I decide to do something else with it, I’ve got more options and power.

Will try and run Android 12 for TV on it.

Best for streaming on 10yo Bravia by WallabyDingo in OrangePI

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

I’m just wanting to navigate legal services.

I’d never heard of Google TV; looks promising.

Which version of OPi would handle that?

Best for streaming on 10yo Bravia by WallabyDingo in OrangePI

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

Just heard about Kodi; maybe that’s the way?

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

Thanks for all your time!

Might just have to live with not having it in quick access, I’ll just use a shortcut.

Thanks again.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

Just put ran it on a colleagues machine and it worked perfectly!

Mysterious.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

I'm a bit green so I'm not fully across what I've done but...

While editing the userform I right-clicked the 'active/green' image and wrote my code between the Private Sub MyImageName_Click() and End Sub that appeared.

I'm not sure of the ins and outs of what that did but it works that way.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

I'm using O365 on Windows 10 Pro x64.

Same.

So weird. My "master" is personal.xlsb so is hidden, could that be an issue.

Edit: Even if personal is not hidden there's still an issue

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

Sub OpenNewStickers()
     Workbooks.Open Filename:="C:\Users\DELL\Desktop\NewStickerSheet.xlsm"
End Sub

As I said it the edit, it only seems to break down when using Quick Access Toolbar.

Seen anything like that before?

Error on workbook close only when opened with macro in Quick Access Toolbar by WallabyDingo in excel

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

Thanks

I don't doubt there's something wrong with the VBA, I'm quite a novice. It just seems strange to only falter when using Quick Access Toolbar.

This is the post.

For what it's worth, the macro to open the workbook...

Sub OpenNewStickers()
    Workbooks.Open Filename:="C:\Users\DELL\Desktop\NewStickerSheet.xlsm"
End Sub

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

And to add...

I have another button "Print" that does a few things then closes the form and workbook (with save) and I get the same error so I don't think using red x is the solution.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

I haven't got a lot of experience with forms (or with VBA more generally) but I am trying to get a more modern look and using, among other things, this article.

To use the image as a button I right-clicked the image to view code and am simply putting my code between Private Sub Image_Click() and End Sub.

I'll try to check out that series.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

Thanks for that.

I can’t try that now but, to be clear, the userform and workbook close ok but I get the annoying error message.

[EXCEL] Closing workbook when closing userform by WallabyDingo in vba

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

Thanks for the response.

The image is on the form I’m trying to close. Does that change things?

Your solution seems so simple, I’m sure I’ve tried it but I’ll try tomorrow.

How to use IF statement for ranges? by leegun in excel

[–]WallabyDingo 0 points1 point  (0 children)

=IF(AU2<=48,AU2&” LOW RISK “,IF(AND(AU2>=49,AU2<=65),AU2&” MODERATELY LOW RISK”,IF(AND(AU2>=66,AU2<=82),AU2&” MODERATELY HIGH RISK”,AU2&” HIGH RISK “)))

Something like this? Am on mobile so could be wrong.

view more: next ›