Disaable all or a type of fields when user form opens

ootkhopdi

Board Regular
Joined
Sep 30, 2013
Messages
68
Hi

i want to display records in user form "frm_r"
it having many records in many text boxs..
i want to disable all text boxs when open form or form view as read only untill Btn_updt not clicked..

please tell me how can i do it..

thanks in advnce
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
You can disable/enable all the textboxes on a userform with code like this.
Code:
Dim ctl As MSForms.Control

    For Each ctl In Me.Controls
        If TypeName(ctl) = "TextBox" Then
            ' toggle Enabled property
            ctl.Enabled = Not ctl.Enabled
        End If
    Next ctl
 
Upvote 0
Thanks Norie ,, but code is not working
now i m doing as all textbox are set in a frame.. which enable property is false mean it is disable.

so all textboxs are disabled now..after click on btn_update all properties change to enable. for enable text boxs..

thanks once again
 
Upvote 0
How is it not working?

How did you try it?
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top