application.inputbox

Hi Experts Need some help I want to Copy Paste Only Border Style and No Other Formatting in Excel for Mac 2019 I got this code from some site, but it copies entire formatting. Please help me improve the code specific to my needs. Thanks a lot ? Sub CopyBorders() ' ' CopyBorders Macro ' '...

I've been following Andrew Gould's VBA Introduction video series on YouTube and everything was running fine up till episode 11.2 - Application.InputBox I type in Andrew's code letter-for-letter, you may compare it e.g. https://youtu.be/NvGv1n4TW28?t=1144 So when I type in the code I get 1004...

Option Explicit Sub AreaOfTriangle () Dim a As Long, b As Long , Aunit As Variant On Error resume Next a = Application.InputBox ("Enter base of triangle" , Type:=1) b = Application.InputBox ("Enter height of triangle" , Type:=1) Aunit = Application.InputBox ("Enter unit of measurement "...

Everything is working fine in the below code, except when the application input box for some reason will not show the marching ants around the cells I select. The code still functions properly and it does select the cells I click on with my mouse, but from a user's point of reference it seems...

I've put in the following code and it seems to work well. Now I'm wanting to add an input box to tell the user to select a "case" instead of using the cell selected before clicking the button I have assigned to this macro. Here's the code I have that is working Sub MoveCase() 'Move Case...