UserForm to View and Edit data in a closed workbook

Hi Everyone,

I would like the form i created to find data from a different workbook, then if needed i will be able to change the data in the other workbook.

I failing at the first hurdle, getting the information to show in the userform!

My initial thought (as seen in the Search.xlsm Document) is to have the vba open the document then close it once it has retrieved the search, is this best practice or is there another way to do this?

Ive tried myself to get it working however it wont do it and i get an error so i must be missing something somewhere so i would greatly apreciate your help.

Capture.PNG

im also confused on how i would get the check box to check if cell = "Y"

TIA

all i get is no such number however that number is definately in there

if you are searching in column c when the criteria starts at a previous column, then use MATCH and INDEX. plenty of help on the internet for that.

Originally Posted by mtwa1990

all i get is no such number however that number is definately in there

Post your changed code.

This is what i have updated to the above code

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

fantastic thank you, now you maybe able to help with how i would put code in to enable me to update the workbook when i click update.

For example if i change the outcome to complete and click update then that would change that information in the workbook, i only need it for the email tick box, the process stage and outcome text box

Please Login or Register  to view this content.

would that code change much if i swapped the numbtxt textbox with the idtxt textbox?

so now the search form will look for the ID number in column G instead of the number in column A, so when i change the data and click update_click how will that code youve sent change?

temp = me.numbtxt will now become text =me.idtxt however i do not know how to change the rest.

Did you change the order of myList?

I didn't looked at carefully...

If you give me the column index that matches to each control names, it would be easier.

numbtxt - column 1
contacttxt - column 2
exttxt - column 3
storetxt - column 4
mgrtxt - column 5
mtrtxt - column 6
idtxt - column 7
admintxt - column 8
officetxt - column 9
valuetxt - column 10
securetxt - column 11
emailchk - column 12
stagetxt - column 13
outcome - column 14
commentstxt - column 15

Then try change myList to

Please Login or Register  to view this content.

What i mean is when i enter a number in the search box i want it to search for that number in column 7.

How do i then update that information as the code you supplied above will only work looking for the value in the 1st columns then change the data in the rest of the columns

I want it to find the value in the 7th column and change the data in columns 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15

change to

Please Login or Register  to view this content.