Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

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.User generated imageAnd yes I had added one column and all other buttons doesn't working, pop up error message.

Thanks
Incoporated-Download-File-V19.xlsm
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

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
Avatar of Naresh Patel

ASKER

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
And yes all are check boxes.
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
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Awsome
Great !!! I left room if you need to add buttons if not we can squeeze them back
gowflow
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
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
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
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