Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Activex text box in shared environment

0

I'm using a shared workbook and want to filter data (table) using an activex tekstbox and filter while typing. This works OK, but it does not work in a shared workbook using 365. Getting all sorts of error messages and the workbook does not save properly. 

The search works, but the problem seems to be that I'm using the activex box to link to a spesific cell and using that as filtercriteria as I'm typing. Seems to me that one can't use activex in shared workbooks. Anyone hwo can guide me on that?

Answer
Discuss

Answers

0

Bjtor

I think I got something like that working on a shared book (but I can't share that so here's a description...)

I created simple data in $A$3:$B$16 but hid the rows (but leaving titles visible in row 2). I created and displayed a named SheetView. I then inserted an ActiveX combox box and set these properties:

ListFillRange $A$3:$B$16

Linked Cell SD$3

so whatever value is picked from the combox box will appear in cell D3.

Below the hidden rows (and titles), in A18 I put this array formula:

=FILTER(A3:B16,ISNUMBER(SEARCH(D3,A3:A16)))

that searches for whatever is in D3 (from the combobox) in the range A3:A16 and filters for that data range A3:B16. If I pick Item 6 (which has 3 entries in my example), I get this in the cells A17:B19, below the titles:

Item 6 56
Item 6 61
Item 6 56
.

Hope you can follow this / it's what you need.

Discuss

Discussion

Hi!
Maybe I did not explain myself well enough. I have no problem creating the search function. The problem is that EXCEL in 365 shared workbook gives an error because the search box is ActiveX. If I only use one cell as a "search box" it works fine, but Change is not true until you press enter. In an ActiveX box Change is true for each letter you type. That's why I want to use ActiveX linked to a cell. Gets an error message when you exit the workbook and excel offers and save with another name.
Bjotr (rep: 6) May 24, '22 at 5:56 am
Bjotr. I still don't understand the issue fully (and not sure why your discussion point above looks like you pasted into a CODE box for some reason).

It nearly always helps to have a file to look at (but your problem should be described in the question, not the file nor the dicsussion). Please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. Then we should be able to give specific help.
John_Ru (rep: 6102) May 24, '22 at 6:36 am
Bjotr, can you upload a representative Excel file, as requested, to help?
John_Ru (rep: 6102) May 26, '22 at 12:46 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login