Search:

Type: Posts; User: ootkhopdi; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Find Column Heading Based on cretera in 2 rows

    Thanks Novic , But your solution is not given answer,
    i think , my problem is not clear.

    please see table as


    <colgroup><col style="mso-width-source:userset;mso-width-alt:1393;width:29pt"...
  2. Find Column Heading Based on criteria in 2 rows

    hi all

    i have a table with more than 100 rows and 100 columns

    in this table upper most 3 rows are having column titles.

    i want to get column heading of particular column,
    in which row 2...
  3. Replies
    1
    Views
    236

    Disable Control in Tab

    HI

    I am using Office 2016
    I want to disable unprotect sheet or unprotect workbook option when someone open this protected workbook..

    how can i do it??


    thanks in advance
  4. Enable locked cells in protected sheet with userinterfaaceonly

    HI All

    i have a workbook with sheet "1"
    when i open workbook this code is runs and works..
    Private Sub Workbook_Open()
    Sheets("1").Activate
    With Sheets("1")
    .EnableAutoFilter = True...
  5. Re: Conditional Formatting of A Column With Cell Value Change in Row

    Private Sub Worksheet_Change(ByVal Target As Range)
    I Solve the Problem with this code
    you can change target colour as you like

    "Dim x As Integer
    x = Target.Column
    If Target.Address <>...
  6. Re: Restrict All Textboxes which are in a frame to Allow input Numbers only

    My Mean by "Number" is Digits only . no decimal point ,no plus or minus sign.
  7. Restrict All Textboxes which are in a frame to Allow input Numbers only

    Hi..

    i have a user form Named"Form1"
    in this form i have 2 frames Fr1 and Fr2
    in fr2 i have 10 textboxes..

    i want to restrict only Number value in all text boxes of Fr2
    how can i do it.....
  8. Re: Disaable all or a type of fields when user form opens

    Thanks Norie ,, but code is not working
    now i m doing as all textbox are set in a frame.. which enable property is false mean it is disable.

    so all textboxs are disabled now..after click on...
  9. Disaable all or a type of fields when user form opens

    Hi

    i want to display records in user form "frm_r"
    it having many records in many text boxs..
    i want to disable all text boxs when open form or form view as read only untill Btn_updt not...
  10. Re: Change Back ground Colour of Text box on evnt( Enter, Exit, Value Changed)

    thanks fluff for early reply..but it will be a lengthy code and may be some error.

    so i want to code for every text box..
    thanks. i am also trying to write this..
  11. Re: Change Back ground Colour of Text box on evnt( Enter, Exit, Value Changed)

    Thansk Fluff. i got this..

    but there is a problem. i want to this code run for every textbox of form, My textbox are 40 in number with diffrent type of format, Like Text, Date and Number...
    so...
  12. Change Back ground Colour of Text box on evnt( Enter, Exit, Value Changed)

    Hi.
    i have created a user form having 10 textboxes name tb1. tb2.....
    i want to change background colour of text box,
    when i enter , it becomes yellow,
    when i change value of it, it changes to...
  13. Re: IF Cell value is given error then show warning msg as user form

    Can some one tell me how can go direct to row of other sheet which cantains value = text box1 value in column c.
    means textbox1 value is working as hyperlink address
  14. Re: IF Cell value is given error then show warning msg as user form

    Thanks ajamess. This code gave me a way to solution.. thanks
  15. IF Cell value is given error then show warning msg as user form

    hi all

    i have create a worksheet in which cell "c4" value is filled by input box value..
    i want to create warning user form which show on error i.e.

    cell c4 is blank or cell value of C4 given...
  16. Replies
    1
    Views
    115

    Change Cell Value into Hyperlink

    Hi..

    i want to change cell value as hyperlink after typing it

    like ..
    when i type in cell " d5" as "Ankur"
    it converts for Hyperlink to Go to Sheet Named "Ankur" and cell A5

    is it...
  17. Thread: Welcome

    by ootkhopdi
    Replies
    54
    Views
    123,251

    Sticky: Re: Welcome

    Hello Riaz.. can you tell me how...
  18. Thread: Welcome

    by ootkhopdi
    Replies
    54
    Views
    123,251

    Sticky: Re: Welcome

    /kU;okn~!!!/kU;okn~!!!

    Sorry Joe4
    i paste Thanks in Hindi Fonts ,after typing it in MS Word..

    But it show like this..

    . I think i want to type in roman hindi..

    Dhanyavad....
  19. Thread: Welcome

    by ootkhopdi
    Replies
    54
    Views
    123,251

    Sticky: Re: Welcome

    How can i use in hindi
  20. Thread: Welcome

    by ootkhopdi
    Replies
    54
    Views
    123,251

    Sticky: Re: Welcome

    how can i type in other languages???
  21. Re: Problem in run macro after cell value change in sheet

    T3 is cell address
  22. Re: Conditional Formatting of A Column With Cell Value Change in Row

    Thanks james..

    i want like this.

    when value of range A3:BZ3 is changed in any cell like , in a3 or d3 or in z3,,
    cell colour of changed cell( a3,d3 or z3) should be change as well as cell...
  23. Problem in run macro after cell value change in sheet

    hi all
    i am trying to run a macro(MacroA) when value of cell T3 is changing

    i m trying many times but its not working..
    i cant understand what is happening..
    i use this code several times but...
  24. Re: Conditional Formatting of A Column With Cell Value Change in Row

    No. I want a simple code..
    or
    if event macro is a code ,which run after change value, i think it right,,

    but i have little knowledge about it, so not confirmed..

    please give me aan example...
  25. Conditional Formatting of A Column With Cell Value Change in Row

    Hi.

    I have a database in sheet
    I Want to change Colour of Cell A5 and related Cell, if Any Value of Cells A5:Z5 is Changed..
    i have a code which changed cell colour , if cell value or cell...
Results 1 to 25 of 63
Page 1 of 3 1 2 3