Deleting columns with dynamic user input

[Ianmacros]

I have a general question. We do a lot of column deletion in our data and the specific columns that get deleted are different for each client's data. I am familiar with how to write a code that deletes specific columns (so we could write a separate code for each client and reuse). However, is it possible to create a VBA code that allows the user to select which columns to delete from a list/message box kind of thing and only write one code that works across clients?

[Roel Jongman]

I'm sure it is..
you could make a double click even where you the headerrow text is replaced by delete
and then have a loop that will delete all columns with the word delete in row 1 (or whichever row is the header)

best thing would post an example of how data will look before and how it will look after explaining what needs deleting and why.

Depending on specific needs it can eighter be a simple code or a more complex code to go from client format to your desired import format, with field mapping to be setup

[Ianmacros]

Thanks, Roel. This is the exact solution I suggested to my boss. However, I was advised that we ultimately have different column headers provided by each client. Since our clients change often, the header labels changes, which would mean continuously updating the code so it can loop through, replace with delete and delete any rows with delete in row 1. I know there's the inputbox function but that seems to be related to inputting data and performing operations versus something like deleting columns, which is closer to a formatting task. Any other suggestions?

[Sintek]

For multiple columns...

Option Explicit

Sub UserInput_Columns_Delete()
Dim Arr As Variant, i As Long
Arr = Application.InputBox("List the column numbers in the following format: " & vbCrLf & "{1, 2, 3}", Type:=64)
For i = UBound(Arr) To LBound(Arr) Step -1
    Columns(Arr(i)).Delete
Next i
End Sub

[Ianmacros]

sintek that is exactly what I needed!

[FlameRetired]

Administrative Note:


For future reference please attend to your thread titles. This thread title does not really convey what your request is about.

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.