IrishCharm
09-16-2009, 08:25 AM
Hi,
I have a list box which i add data into and you basically tick one box in each. But i cannot seem to be able to identify the actual box being ticked. Any helo would be great - the macro that runs is the big white button and in the macro "Compile_Spreadsheet" is where i am looking at pulling in the data that is ticked but it is not coming in correctly for example if i tick "EUR" it may bring back in "GBP" as this is the last ccy on its list.
0: Hit the white button to kick off the macro
1: Hit the Import All Data button.
2: Tick the boxes (1 in each section) that you want
3: Hit the Run Report button - this should bring you into the Compile_Spreadsheet macro for which those ticked variables are brought back but i cant seem to do this correctly.
I have a list box which i add data into and you basically tick one box in each. But i cannot seem to be able to identify the actual box being ticked. Any helo would be great - the macro that runs is the big white button and in the macro "Compile_Spreadsheet" is where i am looking at pulling in the data that is ticked but it is not coming in correctly for example if i tick "EUR" it may bring back in "GBP" as this is the last ccy on its list.
0: Hit the white button to kick off the macro
1: Hit the Import All Data button.
2: Tick the boxes (1 in each section) that you want
3: Hit the Run Report button - this should bring you into the Compile_Spreadsheet macro for which those ticked variables are brought back but i cant seem to do this correctly.