varuserinput

Hi all, Apologies for the simple request as a beginner to the forum, but I would like to have a button on a spreadsheet that I can delete either a specific column or row. I have code to remove a column as follows: Sub DeleteColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter...

Hi, I am very much a beginner with excel, but wanting to add a button on my spreadsheet to add a column after a specific column. The code I have put together is as follows: Sub AddColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter Column Letter where you want to add a...

i have searched a bit and all i get doesn't really suit what i needed. Totally new to VBA but what i am trying to achieve is insert a new row below(either highlighting the whole row or just a cell), copy everything above (format, formula, conditional formatting) and then delete content in...

Sub AddAColumn() Dim varUserInput As Variant Dim ColNum As Variant varUserInput = InputBox("Enter Column Number where you want to add a Column:", _ "What Column?") If varUserInput = "" Then Exit Sub ColNum = varUserInput Rows(ColNum & ":" & ColNum).Insert Shift:=xlDown Rows(ColNum...

Hello Geniuses! I am creating a form and trying to make it as user friendly as possible, creating command buttons that will automatically copy all formulas and data validations from the current line, and insert them in the desired row (same sheet). For some reason, this isn’t copying my...

Hello, I have the code below which I would like to add to: Sub New_Risk() Dim varUserInput As Variant varUserInput = InputBox("Enter Row Number where you want to add a row:", _ "What Row?") If varUserInput = "" Then Exit Sub RowNum = varUserInput ActiveSheet.Unprotect "test" With...