Excel - Forms

I have a worksheet and would like to create a form and link the worksheet to
it.

Then, if I enter information into the worksheet it would also appear in the
form and vise versa.

Does anyone know how to do this and also create a data form please?

  FSt1 replied to MarkOffice2007

hi
see this site......
http://www.contextures.com/xlUserForm01.html

as to the linking, use the Linked Cell Property of the text box control.

Regards
FSt1

working VAT in worksheet Excel Hi all I have a worksheet like below, It might be easy for some but i'm a bit rusty. F8 depending where i have put the amount. Hope this makes sense! Many thanks Tina Excel Worksheet Discussions Intersect (1) Excel (1) Named range (1) Worksheet (1) VBA (1) Toppers (1) CellSo (1) Tina (1) = IF($F$10 = "", rond(F8*vat H9 so if i enter data in F9 the answer will be in H9 and vise versa and then maybe enter a formula in G10 to show the VAT. Can this kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk keywords: working, VAT, in, worksheet description: Hi all I have a worksheet like below, It might be easy for some but i'm a bit rusty. F8

Worksheet Comparison Excel I have a small family business and need to be able to compare cells from sheet1 to sheet2 via macro. Each worksheet has a different number of rows and columns. Conditional formatting would be great but not macro montly to validate data collected. Hope you can help me. Thanks! Excel Programming Discussions Worksheet (1) Range (1) Please supply more specific information on what you want? Is the header in one row. The header from sheet1 will never be a header in sheet2 and vise versa. Sheet1 header may be in multiple cells in different rows and / or columns on hope this is clearer. Working this through has been a challenge today. Thanks again. keywords: Worksheet, Comparison description: I have a small family business and need to be able to compare cells from sheet1 to sheet2 via macro. Each worksheet has a different number of rows and

the value of the column, from bottom up, changes sign (from positive to negative or vise versa.). As soon as the sign is changed or the number is the value of 0 12.2 -11.1 3.2 counter = 3 counter = 2 counter = 1 Thanks. Excel Worksheet Discussions Excel 2003 (1) Excel 2007 (1) SUMPRODUCT (1) Worksheet (1) Workbook (1) Relative (1) OFFSET (1) MATCH (1) [. . . . ] For the data in A1:A6 a volatile function. So that formula will be recalculated every time any cell in any worksheet in the workbook is edited. If you have a lot of such formulas, that can the value of the column, from bottom up, changes sign (from positive to negative or vise versa.). As soon as the sign is chang

user checks which ever box and clicks the add button it will return to the worksheet a value of YES and vise-versa if they are not checked it will return a value of NO to the When the add button is clicked. Excel Programming Discussions Excel 2003 (1) ActiveSheet.Range (1) Worksheet (1) Approiate (1) Checkbox (1) Vise (1) In the userform module- Private Sub CheckBox1_Change() ActiveSheet.Range("A1").Value = IIf(Me.CheckBox1