Switchboard and untypeable textbox/combo

Midian

New Member
Joined
Jan 2, 2003
Messages
1
I've created my first switchboard, and while trying to add additional features, I've come to a certain roadblock.

I added a textbox, but when I run the form, I can't type into the textbox.

So I tried using a Combo box. The combo box loads the list of data, but I can't select any item in the list.

Is this a known "feature" of the switchboard or am I missing a setting somewhere to allow me to make the selection/entry I want on the switchboard form?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
hi,

If you go into design view of the switchboard form, and look at the properties of the form itself, you'll see that allowedits is set to 'No'. So that's why you can't edit. If you set it to 'Yes', you can edit. However there may be a reason why it's currently set to No.

dave.
 
Upvote 0

Forum statistics

Threads
1,221,503
Messages
6,160,193
Members
451,630
Latest member
zxhathust

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