Radio Buttons

Hi Experts,

I have one file which download data from web to particular assign location. But before downloading it delete old files from that locations so I need selection to delete or not to delete old files via radio buttons.Radio ButtonsAnd yes I had added one column and all other buttons doesn't working, pop up error message.

Thanks
Incoporated-Download-File-V19.xlsm
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
The way you created these buttons will generate tremendous work as almost each and every sub in this workbook will need to re-allocate Col A,B,C,D,E,F to now B,C,D,E,F,G which is a huge work !

Is this your final request and you need to see those in Col A ? or could we squeeze them in Col B and make it a bit larger so we don't add a column and complicate life ?

You mention Radio button but what you installed is a Checkbox button (Radio button will only accept 1 ON and all the rest OFF) where as checkbox can accept many ON and Many OFF so presume you want Checkbox.

Pls advise what will be the scope of this question as too much manipulation in code here.

gowflow
0
Naresh PatelTraderAuthor Commented:
Sir,
Place in column B. After posting I tried to run the file but getting error . Even in thought instead of placing this new buttons in column A I have to place in column H. So it won't affect the existing setup. My bad. Place where ever which required least modification in code.
Thanks
0
Naresh PatelTraderAuthor Commented:
And yes all are check boxes.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

gowflowCommented:
Also any other button you envision as in your last post you mentioned also Zip/Unzip so we need to account for everything or else will be chasing our tail !!
gowflow
0
gowflowCommented:
ok pls try to see if this is what you want. You will notice a toggle of the checkbox between Del (to delete the files) and Keep (to keep them and not delete them)

for each button is corresponding its checkbox.

Pls try it in all scenarios and let me know.
gowflow
Incoporated-Download-File-V20.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naresh PatelTraderAuthor Commented:
Sorry Sir for delay in reply .....I am on my way back to home ...Give me 1 hour to reply you back.

Extremely sorry for delay.
0
Naresh PatelTraderAuthor Commented:
Awsome
0
gowflowCommented:
Great !!! I left room if you need to add buttons if not we can squeeze them back
gowflow
0
Naresh PatelTraderAuthor Commented:
it is possible to add two more check boxes which allow me to select only download and only formatting (Unzipping & formatting). if both unchecked then download plus formatting done by default....?

if yes then before go for above implementation, need 3 more formatting required & this will be the last request on this file.

May post new question?

Thanks
0
gowflowCommented:
ouch !!! don't you think your overdoing it ???

Why this request ? do you happen to have some files that need formatting and other no ? some need download and others no ? I mean under the same option for sure like under the same Delivery or Equity  etc.. ??

Too many buttons will render it too crowded don't you think ?
gowflow
0
Naresh PatelTraderAuthor Commented:
Eagle eye :)

I think you are right ....I am making complicated.

but 3 type of formatting required which is not so much complicated i.e. NSE Eq - BSE Eq - Index
for that want to ask 3 more questions...May I ? it is just convert in .txt file.

Thanks
0
gowflowCommented:
Sure as these are I think essential as some of your routine have formatting and other don't so please go ahead and ask.
gowflow
0
Naresh PatelTraderAuthor Commented:
Here It Is.

Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.