Using RC with Relative References

Imagine you are entering a formula in a cell. To point to a cell in a formula, you use the letters R and C. After each letter, enter the number of rows or columns in square brackets. For columns, a positive number means to move to the right a certain number of columns, and a negative number means to move to the left a certain number of columns. From cell E5, use RC 1 to refer to F5 and RC -1 to refer to D5. For rows, a positive number means to move down the spreadsheet a certain number of rows....

Using a Scrollbar as a Slider to Select Values

Access Userform

Chapter 9 discussed using a spin button control to allow someone to choose a date. The spin button is good, but it allows clients to adjust up or down by only one unit at a time. An alternative method is to draw a horizontal scrollbar in the middle of the userform and use it as a slider. Clients can use arrows on the ends of the scrollbar like the spin button arrows, but they can also grab the scrollbar and instantly drag it to a certain value. The userform shown in Figure 21.12 includes a...

Universal File Format

For many years, CSV was considered the universal file format. Just about any application could produce data in comma-separated values and just about any spreadsheet could read in CSV data. XML promises to become the universal file format of the future and it is far more powerful. You may deal with CSV data every day. As developers, we need to talk to the other developer who is generating the CSV data, and we have to understand that the fifth column contains a zip code and the sixth column...

Adding Graphics to a User Form

Animation Excell Dans Userform

ggj A listing on a form can be even more helpful if a corresponding graphic is added to the form, as shown in Figure 9.12. The following code displays the photograph corresponding to the selected employee from the ListBox Private Sub lb_EmpName_Change Dim EmpFound As Range With Range EmpList Set EmpFound .Find lb_EmpName.Value If EmpFound Is Nothing Then MsgBox Employee not found lb_EmpName.Value tb_EmpPosition .Offset 0, 1 tb_HireDate .Offset 0, 2 On Error Resume Next Img_Employee.Picture...