Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Trying to develop a spreadsheet to do pair-wise comparisons and need
some help on the strategy to implement. Have 10 items in a single column. Want to compare row 1 with 2, 3, 4...., then row 2 with 3, 4, 5..., then 3 with 4, 5, 6..., etc. I put together a userform that gets the items and allows you to select a radio button to choose between each fo the two. I am struggling with the following: Want the user to keep pressing a next button on the userform after making their selection. Each press will write the two items on the sheet, identify which was selected and then go get the next two items to compare. Not sure how do do this with an On_Click event for the button. You have to keep track of the first and second comparison items, but each time you Click the button, the code starts back at the top of the subroutine. Do you track the items outside the On_Click and pass parameters? Any help would be appreciated. Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data on UserForm to different sheet based on day of week chosen? | Excel Programming | |||
Need assistance to populate sheet from Userform data | Excel Programming | |||
data from userform to a cell on an execel sheet | Excel Programming | |||
problem getting data from sheet into txt_boxes in userform | Excel Programming | |||
Userform data to Excel sheet. | Excel Programming |