Input part numbers and description into selected spreadsheet
Closed
antkerr
Posts
1
Registration date
Sunday January 21, 2018
Status
Member
Last seen
January 21, 2018
-
Updated on Jan 21, 2018 at 05:49 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 22, 2018 at 09:08 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 22, 2018 at 09:08 PM
Related:
- Ge cannot be displayed. (80710a06)
- Free fire id transfer facebook to google description - Guide
- How to input @ in laptop - Guide
- Lg tv change input name ✓ - Smart TV Forum
- Input phone password - Phones, PDA & GPS Forum
- Google input tools - Download - Mouse and keyboard
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jan 22, 2018 at 04:23 AM
Jan 22, 2018 at 04:23 AM
Hello Antkerr,
Could you please upload a sample of what you have done so far with your workbook showing inputs and expected outputs and showing exactly how you have the data set out. This will make it easier for us to understand what you would like to do and to do some testing.
You can upload a sample to a free file sharing site such as GE.TT or Drop Box and then post the link to your file back here.
In the meantime, here is some homework for you. Have a look at the following link:-
https://www.exceltrick.com/how_to/insert-a-checkbox-in-excel/
This is a very good example of how to set up tick (check) boxes and is very easy to follow. This will save us some time in trying to resolve your query.
Cheerio,
vcoolio.
Could you please upload a sample of what you have done so far with your workbook showing inputs and expected outputs and showing exactly how you have the data set out. This will make it easier for us to understand what you would like to do and to do some testing.
You can upload a sample to a free file sharing site such as GE.TT or Drop Box and then post the link to your file back here.
In the meantime, here is some homework for you. Have a look at the following link:-
https://www.exceltrick.com/how_to/insert-a-checkbox-in-excel/
This is a very good example of how to set up tick (check) boxes and is very easy to follow. This will save us some time in trying to resolve your query.
Cheerio,
vcoolio.
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jan 22, 2018 at 09:08 PM
Jan 22, 2018 at 09:08 PM
Hello Antkerr,
There appears to be a few problems with the buttons on your main sheet. A "Subscript out of range" error appears when one clicks on the buttons. This generally means that the code cannot find the correct sheet which means that the codes have not been assigned to the correct buttons. So, that's your next homework assignment! Assign the correct code to the buttons.
How are the tick boxes coming along? We'll need to see how you have set them up before we can create a macro to do the transferring of data to the "Pick" sheet. When you have sorted out these two items, upload a new working sample and we'll then be able to put the finishing touches to your workbook.
BTW, when you allocate the link cells to the tick boxes, pick a column out of sight of your main input areas (such as Column Z). We only need the True/False values to work with. These are built in functions with the tick boxes and will appear in the link cells automatically. You will not have to add any "IF" statements as per the tutorial.
Cheerio,
vcoolio.
There appears to be a few problems with the buttons on your main sheet. A "Subscript out of range" error appears when one clicks on the buttons. This generally means that the code cannot find the correct sheet which means that the codes have not been assigned to the correct buttons. So, that's your next homework assignment! Assign the correct code to the buttons.
How are the tick boxes coming along? We'll need to see how you have set them up before we can create a macro to do the transferring of data to the "Pick" sheet. When you have sorted out these two items, upload a new working sample and we'll then be able to put the finishing touches to your workbook.
BTW, when you allocate the link cells to the tick boxes, pick a column out of sight of your main input areas (such as Column Z). We only need the True/False values to work with. These are built in functions with the tick boxes and will appear in the link cells automatically. You will not have to add any "IF" statements as per the tutorial.
Cheerio,
vcoolio.
Jan 22, 2018 at 06:19 AM
https://www.dropbox.com/s/d23xdq2d4ukodwv/WORKSHOP.xlsm?dl=0