Search results

ty for the try mohadin but cant understand how to make this list work?

I have a workbook that have 2 userforms userform12 and userform 15 but the second userform15 open when i click in a textbox txt17 in userform12 >>> use code - tags <<< Private Sub txt17_Enter() Me.cmbslno.Copy Unload Me UserForm15.Show End Sub in userform12 there is a textbox that is actually...

both are correct but The second was better. thank you my friend

it's bothers me that code Private Sub TextBox9_Change() TextBox9.Value = Sheets("sheet1").Range("O21").Value End Sub i made a userform with calculation but in one textbox (textbox9) i wanted to bring the value of a cell (o21) with the code i manage to do it but when i run the userform it...

Sorry Chets what are you asking? i have made some adjustments to fit in my project and i find use on another project with a difference the second input to be a dropdown list all same but i have define name a range and that range is a list for the dropbox in the userform something like boy or...

Belleke that's just extremely beyond of what i wanted to do. you are great. but i feel a little bit sad because i would like to come to office after weekend and make my research and tries and you gave me the perfect solution just right in my plate.. lol :) one more time chandoo save me thank...

i had a project to do 3 classes with names of students and ages column A is class 1 in column a is the names of students in column b the age of them column c is class 2 in column c is the names of students in column d the age of them column e is class 2 in column e is the names of students in...

thank you my friend is working just perfect

this is quite easy to run macro when cell value change i found quite easile the code that i wrote it in sheet module {Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("I1:J1") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is...

i rearrange the merged cells and I add this to the line to paste the formula of the cell a1 .Range("T2:T" & n_max) = .Range("A1").Formula for another project that i want to use it the thread is closed have a nice day

you are magician. after some small adjustments it worked thank you

First of all thanks to the community for the help that save me a lot of times second a big sorry for not responding but i was off and i didn't have access to the office and accounts now about your ideas i tested but 2 things i tried too to filter cells but because my sheet has many formattings...

in a range n2:p17000 there are cells with repeatable texts about 400 times winbank winbank2 winbank3 cash cash1 cash2 i am trying to write a code that will search in the range and select all the cells with WINBANK and cash the exact value (not winbank2 or winbank3) but offset 7 columns right...

just for the story and anyone that might consern [Sub HideExcelItems() Application.DisplayFullScreen = False Application.DisplayFormulaBar = True ActiveWindow.DisplayWorkbookTabs = False ActiveWindow.DisplayHeadings = False ActiveWindow.DisplayGridlines = True Application.DisplayStatusBar =...

thank you for your try and i am sorry that i was late to respond and test your solution. it's ok with a small adjustment because for a reason it didn't bring the result inot the cell L2 but now is ok.

I am new in userforms i have made a userform that has 8 boxes with numbers and another that sum that boxes and the result place it to a cell (L2) the wrong is that some numbers are decimels for example 0.33 but in greece we use 0,33 that userform can't calculate right the values with decimels...

ok i get it i didn't know it

no when i use command to hide it hides both the all sub is Sub HideExcelItems() Application.DisplayFullScreen = True Application.DisplayFormulaBar = True ActiveWindow.DisplayWorkbookTabs = False ActiveWindow.DisplayHeadings = False ActiveWindow.DisplayGridlines = True...

i had tested it and before neither application.display works

i can't manage to work this i want to see the status bar but not the workbook tabs [Sub HideExcelItems() ActiveWindow.DisplayWorkbookTabs = False ActiveWindow.Displaystatusbar = true End Sub]

CLOSE THREAD I manage to do it with some research

i am to a very good point with my toolbar.i have make a lot of progress the only that bothers me and i can't find a solution is that i have make comboboxes with form controls (not activex controls) and i have assign cells that when i select a case from the dropdown to run a macro. for example in...

thank you very much i had that code but i was putting above the case 2.that was my wrong and vletm just help me a lot

I am working with that code [Sub DropDown1_tameio() Dim a As ControlFormat Set a = Sheet2.Shapes("Drop Down 2").ControlFormat Select Case a.Value Case 2: Application.Goto Worksheets("sheet").Range("A1") Case 3: macro1 End Select End Sub] case 2 is just a hyperlink to move between sheets and...

i found a working way for my purpose with that code [Sub DropDown1_tameio() Dim a As ControlFormat Set a = Sheet2.Shapes("Drop Down 2").ControlFormat Select Case a.Value Case 2: Application.Goto Worksheets("sheet").Range("A1") Case 3: macro1 End Select End Sub] i categorize my 22...