Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi everyone, I have a listbox and I want to add an item to this listbox based on what the user enters in the InputBox. I'm getting a permission denied error. Any ideas? Here's my code: Private Sub CommandButton5_Click() StudyInput = InputBox("Please enter the new study") ListBox1.AddItem StudyInput End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Maybe you forget the userform name
Userform1.ListBox1.AddItem StudyInput Best Regards Bill -----Original Message----- Hi everyone, I have a listbox and I want to add an item to this listbox based on what the user enters in the InputBox. I'm getting a permission denied error. Any ideas? Here's my code: Private Sub CommandButton5_Click() StudyInput = InputBox("Please enter the new study") ListBox1.AddItem StudyInput End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Access Denied | Excel Discussion (Misc queries) | |||
Access denied | Excel Discussion (Misc queries) | |||
Secondayr axis denied | Charts and Charting in Excel | |||
Worksheet Access Denied | Excel Discussion (Misc queries) | |||
Error Msg: Permission to use object denied | Excel Programming |