| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform textboxes not allowing input of any kind
Hi
Excel VBA 2016 Pro I have a userform that has 70 textboxes. 1 to 20 and 51 to 70 are data inputs. 1 to 20 work perfectly. 51 to 70 do not allow any input at all. They are all enabled=true I had to write vba keycode, keypress procedures to get them to work. Which works ok. Is anybody able to tell me what has caused VBA text boxes to be dysfunctional. Google search was unproductive and no solutions were found.. There was only one that had a similar problem. Solution was of no help to me. Cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform textboxes not allowing input of any kind
Hi
Excel VBA 2016 Pro I have a userform that has 70 textboxes. 1 to 20 and 51 to 70 are data inputs. 1 to 20 work perfectly. 51 to 70 do not allow any input at all. They are all enabled=true I had to write vba keycode, keypress procedures to get them to work. Which works ok. Is anybody able to tell me what has caused VBA text boxes to be dysfunctional. Google search was unproductive and no solutions were found.. There was only one that had a similar problem. Solution was of no help to me. Cheers Is the *Locked* Property set to *False*? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform textboxes not allowing input of any kind
On Thursday, February 14, 2019 at 1:32:01 PM UTC+13, GS wrote:
Hi Excel VBA 2016 Pro I have a userform that has 70 textboxes. 1 to 20 and 51 to 70 are data inputs. 1 to 20 work perfectly. 51 to 70 do not allow any input at all. They are all enabled=true I had to write vba keycode, keypress procedures to get them to work. Which works ok. Is anybody able to tell me what has caused VBA text boxes to be dysfunctional. Google search was unproductive and no solutions were found.. There was only one that had a similar problem. Solution was of no help to me. Cheers Is the *Locked* Property set to *False*? -- Garry GS textboxes dont have "Locked" property. the form enabled property is true |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform textboxes not allowing input of any kind
On Thursday, February 14, 2019 at 1:32:01 PM UTC+13, GS wrote:
Hi Excel VBA 2016 Pro I have a userform that has 70 textboxes. 1 to 20 and 51 to 70 are data inputs. 1 to 20 work perfectly. 51 to 70 do not allow any input at all. They are all enabled=true I had to write vba keycode, keypress procedures to get them to work. Which works ok. Is anybody able to tell me what has caused VBA text boxes to be dysfunctional. Google search was unproductive and no solutions were found.. There was only one that had a similar problem. Solution was of no help to me. Cheers Is the *Locked* Property set to *False*? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion That was the problem thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check is input textboxes is numeric on userform | Excel Programming | |||
| userform & textboxes | Excel Programming | |||
| File input though some kind of windows interface | Excel Programming | |||
| userform textboxes again | Excel Programming | |||
| userform textboxes | Excel Programming | |||
Linear Mode
