Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 19, 11:14 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2019
Posts: 3
Default 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   Report Post  
Old February 14th 19, 12:31 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 982
Default 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   Report Post  
Old February 14th 19, 12:49 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2019
Posts: 3
Default 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   Report Post  
Old February 14th 19, 12:55 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2019
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
check is input textboxes is numeric on userform Jean-Pierre D via OfficeKB.com Excel Programming 7 August 16th 05 08:15 PM
userform & textboxes beginner Excel Programming 3 July 27th 04 10:56 AM
File input though some kind of windows interface Philipp Oberleitner Excel Programming 2 July 9th 04 01:25 PM
userform textboxes again Jo[_6_] Excel Programming 4 October 21st 03 07:25 PM
userform textboxes Jo[_6_] Excel Programming 4 October 21st 03 07:15 PM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017