PDA

View Full Version : User cannot select items in a Listbox



paddysheeran
04-22-2015, 08:50 AM
Hi All,

I have a list box on a sheet which is re-populated when there is a change on the sheet.

Myself and a colleague can select the items in the listbox without a problem but another user is not able to select them. We get a pointer and the ability to select. The user gets a + and cannot select the items.

any ideas why this could be happening and is there a quick fix?

thanks,

paddy.

mancubus
04-22-2015, 02:39 PM
hi.

close all applications.
open temp folder.
delete all files and subfolders that can be deleted. (to be specific all files with "exd" extension.)
try again.

paddysheeran
04-23-2015, 02:24 AM
hi.

close all applications.
open temp folder.
delete all files and subfolders that can be deleted. (to be specific all files with "exd" extension.)
try again.

how do you locate the temp folder?

mancubus
04-23-2015, 03:01 AM
in windows explorer address bar write %temp% and press enter key.

in most of the companies (as is the case in my company :) ) users are not allowed to access folders in C drive. you may need to ask help from IT security, system security, etc department.


try:

Msgbox Environ("temp")

or to display in Immediate Window

Debug.Print Environ("temp")

or when in Immediate Window write below then press Enter

?Environ("temp")

visit:
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx