Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Command Button Problem..
Hi All,
Developing a UserForm with CommandButtons, one for each week of the year. I first inserted CB's (1-13) in a row representing the first Qtr of the year, then copied and pasted this column across the Form. In the process of moving the rows of buttons to their respective spot, I didn't keep them in order and had to rename them to keep some order in the form. Problem....when I got to the fourth column of CB's, the first one should be labeled CommandButton40 but I got the "Could not set the Name property. Ambiguous Name.".....then tried the number 41 with the same results until I got to the number 53, which the form allowed. There are no other buttons on this form, and in looking through the dropdown at the top of the properties window, there are no CommandButtons 40 thru 52 listed, so I'm not sure why I'm getting this error msg. One thought just came to mind...I did paste one too many rows of buttons, and deleted one of these rows. These may have been numbered 40-52. So, for a test, I opened a new sheet and tried to duplicate the error......made a row of CommandButtons (1-4), copied and pasted that row twice, ending up with two more columns of buttons numbering (5-8 & 9-12). I deleted the middle row (5-8) and then renamed (9-12) to (5-8).....the new names were accepted with no problem. It would appear that the deleteing of the row in my original form is not the problem. Any help explaining this would be greatly appreciated. TIA, Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Command Button Problem..
I have not been able to determine what caused the problem but if you give
each button a unique name such as 'wk1, wk2' etc that might avoid problems and still allow you to have recognizable names for each button. Just a thought. Jim "Don" wrote: Hi All, Developing a UserForm with CommandButtons, one for each week of the year. I first inserted CB's (1-13) in a row representing the first Qtr of the year, then copied and pasted this column across the Form. In the process of moving the rows of buttons to their respective spot, I didn't keep them in order and had to rename them to keep some order in the form. Problem....when I got to the fourth column of CB's, the first one should be labeled CommandButton40 but I got the "Could not set the Name property. Ambiguous Name.".....then tried the number 41 with the same results until I got to the number 53, which the form allowed. There are no other buttons on this form, and in looking through the dropdown at the top of the properties window, there are no CommandButtons 40 thru 52 listed, so I'm not sure why I'm getting this error msg. One thought just came to mind...I did paste one too many rows of buttons, and deleted one of these rows. These may have been numbered 40-52. So, for a test, I opened a new sheet and tried to duplicate the error......made a row of CommandButtons (1-4), copied and pasted that row twice, ending up with two more columns of buttons numbering (5-8 & 9-12). I deleted the middle row (5-8) and then renamed (9-12) to (5-8).....the new names were accepted with no problem. It would appear that the deleteing of the row in my original form is not the problem. Any help explaining this would be greatly appreciated. TIA, Don |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Command Button Problem..
Thanks for looking Jim,
I did rename the button to CmdBn40 and that was accepted but as far as I can tell "CommandButton40" was and is a unique name, but I still get the same error msg trying to use it. Bottom line is the form works fine, just can't use CommandButton40 thru 52. Ahhhhh the mysteries of Excel.....lol Have a great weekend, Don "Jim Jackson" wrote: I have not been able to determine what caused the problem but if you give each button a unique name such as 'wk1, wk2' etc that might avoid problems and still allow you to have recognizable names for each button. Just a thought. Jim "Don" wrote: Hi All, Developing a UserForm with CommandButtons, one for each week of the year. I first inserted CB's (1-13) in a row representing the first Qtr of the year, then copied and pasted this column across the Form. In the process of moving the rows of buttons to their respective spot, I didn't keep them in order and had to rename them to keep some order in the form. Problem....when I got to the fourth column of CB's, the first one should be labeled CommandButton40 but I got the "Could not set the Name property. Ambiguous Name.".....then tried the number 41 with the same results until I got to the number 53, which the form allowed. There are no other buttons on this form, and in looking through the dropdown at the top of the properties window, there are no CommandButtons 40 thru 52 listed, so I'm not sure why I'm getting this error msg. One thought just came to mind...I did paste one too many rows of buttons, and deleted one of these rows. These may have been numbered 40-52. So, for a test, I opened a new sheet and tried to duplicate the error......made a row of CommandButtons (1-4), copied and pasted that row twice, ending up with two more columns of buttons numbering (5-8 & 9-12). I deleted the middle row (5-8) and then renamed (9-12) to (5-8).....the new names were accepted with no problem. It would appear that the deleteing of the row in my original form is not the problem. Any help explaining this would be greatly appreciated. TIA, Don |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Command Button Problem..
Thanks, Don. I hope your weekend proves to give you needed rest and
re-energizing. Jim "Don" wrote: Thanks for looking Jim, I did rename the button to CmdBn40 and that was accepted but as far as I can tell "CommandButton40" was and is a unique name, but I still get the same error msg trying to use it. Bottom line is the form works fine, just can't use CommandButton40 thru 52. Ahhhhh the mysteries of Excel.....lol Have a great weekend, Don "Jim Jackson" wrote: I have not been able to determine what caused the problem but if you give each button a unique name such as 'wk1, wk2' etc that might avoid problems and still allow you to have recognizable names for each button. Just a thought. Jim "Don" wrote: Hi All, Developing a UserForm with CommandButtons, one for each week of the year. I first inserted CB's (1-13) in a row representing the first Qtr of the year, then copied and pasted this column across the Form. In the process of moving the rows of buttons to their respective spot, I didn't keep them in order and had to rename them to keep some order in the form. Problem....when I got to the fourth column of CB's, the first one should be labeled CommandButton40 but I got the "Could not set the Name property. Ambiguous Name.".....then tried the number 41 with the same results until I got to the number 53, which the form allowed. There are no other buttons on this form, and in looking through the dropdown at the top of the properties window, there are no CommandButtons 40 thru 52 listed, so I'm not sure why I'm getting this error msg. One thought just came to mind...I did paste one too many rows of buttons, and deleted one of these rows. These may have been numbered 40-52. So, for a test, I opened a new sheet and tried to duplicate the error......made a row of CommandButtons (1-4), copied and pasted that row twice, ending up with two more columns of buttons numbering (5-8 & 9-12). I deleted the middle row (5-8) and then renamed (9-12) to (5-8).....the new names were accepted with no problem. It would appear that the deleteing of the row in my original form is not the problem. Any help explaining this would be greatly appreciated. TIA, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a worksheet with a command button on a form | Excel Discussion (Misc queries) | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming | |||
Command button on data-entry form | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming |